Today, I worked at the /Live Person/ IT Help Desk and assisted a student
with her assignment in /Business Research and Analysis/. It's not
complicated.
/Having fun with Microsoft Excel/
This assignment involves working with a set of data containing
information about different charity donors, which might be used to
manage fundraising direct mail or promotional campaigns . You will
learn a few simple tricks for analyzing this data such that you can
extract some useful information and answer some questions. These
instructions are written for MS Excel 2010 or above /(raw data available
on request if you want to try this at home)./
Using Data Sort and Regression
/Sort the data by amount of giving in ascending order by clicking on any
cell in the table and selecting Data, Sort, select column E for Giving
by choosing that in the Sort By drop-down menu, and sort in Smallest to
Largest in the Order drop-down menu.//
//
//Make sure the regression feature is active in your Excel package by
selecting the Office button in the upper left hand corner of the
screen. Select Excel Options at the bottom of the menu, choose Add-Ins,
select Analysis Toolpak-VBA. Then run a regression with years as the
independent (x) variable, and giving as the dependent variable (y).//
//
//Select Data, Analysis, Data Analysis and then choose Regression from
the options. For the y range, highlight the giving amounts of 50,000
and over ($E$217:$E$326); for the x range, highlight the years
associated with these amounts ($C$217:$C$326), click on Line fit plots
to see a graphic representation of the data, and select OK. You might
wish to change the style of the chart to X Y (Scatter) by selecting the
data on the chart and right-clicking.//
//
//The regression results should appear on a new worksheet ply (Sheet
4). If Significance F is <.05, it is unlikely these results happened
purely by chance. The R-square provides an estimate of how much of the
variation in giving can be explained by the length of the relationship.
The x variable is the slope of the line, and can be interpreted to mean
that giving increases by approximately $110,552 for every additional
year the donor has a relationship with the organization.//
//
//Save the file under the name 301Regression. Print the XY chart and the
basic regression stats, showing R-Squared and Significance of F. /