Purpose: To use Excel as a statistical tool to
visualize data and obtain various statistics on a data set; obtain and print a listing of the data; obtain and print
summary statistics of the data; interpret the results.
Tasks:
1. Enter the percentage of computer owners
into the first column of your spreadsheet.
[Click
here for the data]
2. Use the Data Analysis option on the
Tools menu to perform the following procedures:
[If you do not find the Data
Analysis option on the Tool menu, create it by using the Add-Ins and add the
Analysis Tool Pak]
a. Descriptive statistics (print the output)
b. Histogram (print the plot; it’s best to
create a separate chart sheet)
3. Now
enter the following hypothetical sales data on a new spreadsheet (these data
are also on the Excel Sheet used earlier.
|
Quarterly Sales Data |
1998 |
1998 |
1997 |
||
|
|
|
|
Quarter
II |
Quarter
I |
Quarter
II |
|
|
|
|
Projections |
Actual |
Actual |
|
|
|
Region |
|
|
|
|
|
|
Northeast |
441,058 |
331,309 |
306,718 |
|
|
|
Northwest |
291,948 |
222,185 |
200,201 |
|
|
|
South |
149,518 |
118,151 |
101,721 |
|
|
|
|
370,577 |
277,952 |
254,315 |
|
|
|
Southwest |
224,007 |
165,332 |
157,843 |
|
|
|
TOTAL |
1,477,108 |
1,114,929 |
1,020,798 |
Use your spreadsheet program to create a
pie chart and a bar graph of sales for 1998 Quarter II Projections. Have the
output given in relative frequency; that is, in percent of total.