1) Go to the canvas Home page, scroll to bottom of page to the data set Module
2) Select file titled Chapter 2 Assignment Excel
3) Select Download
4) Complete Parts a-c as described below for problem 1 on sheet labeled problem 1
5) Complete Parts a-c as described below for problem 2 on sheet labeled problem 2
6) Once problems are complete save excel file
7) begin submissions by selecting ” start assignment” tab on top of this page
8) select Upload file, Select saved assignment, then select blue “submit assignment” tab
9) Check grades tab in a week to view score on assignment as well as comments I have made to increase improvement for future work.
Problem 1
The following data give the weekly amounts spent on groceries for a sample of households.
$271
$363
$159
$ 76
$227
$337
$295
$319
$250
279
205
279
266
199
177
162
232
303
192
181
321
309
246
278
50
41
335
116
100
151
240
474
297
170
188
320
429
294
570
342
279
235
434
123
325
a. Create a frequency table of 9 classes
b. find and Interpret the mean and median of the distribution
c. find and interpret the variance and standard deviation —————————————–
Problem 2
The monthly issues of the Journal of Finance are available on the Internet. The table below shows the number of times an issue was downloaded over the last 33 months. Suppose you wish to summarize the number of downloads with a frequency distribution.
312
2,753
2,595
6,057
7,624
6,624
6,362
6,575
7,760
7,085
7,272
5,967
5,256
6,160
6,238
6,709
7,193
5,631
6,490
6,682
7,829
7,091
6,871
6,230
7,253
5,507
5,676
6,974
6,915
4,999
5,689
6,143
7,086
a. Find the mean, median, mode, minimum and maximum values as well as variance, standard deviation, range,
b. find Q1,Q2,Q3 and if there are any outliers
c. Find and interpret the 35th percentile and the 90th percentile of the data
0 comments