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 revenue spent for
R&D data in Example 2.11 on page 71 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 expenditures data on a new spreadsheet.
The expenditures of the United States government, in $billion, are
as follows:
(Hypothetical numbers)
Expenditure
Category
|
Expenditures ($bill.) |
|
a.
Defense, State, other national security |
350 |
|
b.
HHS, Education, Social Security, etc. |
400 |
|
c.
Transportation, other infrastructure |
100 |
|
d.
Other |
300 |
Use your spreadsheet program to create a
pie chart and a bar graph of USG expenditures. Have the output given in relative
frequency; that is, in percent of total.