Chapter 2 Exercise is divided in to 2 Problem 1 and Problem 2.Instructions1) Go

Chapter 2 Exercise is divided in to 2 Problem 1 and Problem 2.Instructions1) Go to the canvas Home page, scroll to bottom of page to the data set Module2) Select file titled Chapter 2 Assignment Excel 3) Select Download4) Complete Parts a-c as described below for problem 1 on sheet labeled problem 15) Complete Parts a-c as described below for problem 2 on sheet labeled problem 26) Once problems are complete save excel file 7) begin submissions by selecting ” start assignment” tab on top of this page8) select Upload file, Select saved assignment, then select blue “submit assignment” tab9) 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 1The following data give the weekly amounts spent on groceries for a sample of households.$271$363$159$ 76$227$337$295$319$2502792052792661991771622323031921813213092462785041335116100151240474297170188320429294570342279235434123325a. Create a frequency table of 9 classesb. find and Interpret the mean and median of the distributionc. find and interpret the variance and standard deviation —————————————– Problem 2The 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.3122,7532,5956,0577,6246,6246,3626,5757,7607,0857,2725,9675,2566,1606,2386,7097,1935,6316,4906,6827,8297,0916,8716,2307,2535,5075,6766,9746,9154,9995,6896,1437,086a. 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 outliersc. Find and interpret the 35th percentile and the 90th percentile of the data
Requirements: 1 page

Leave a comment

Your email address will not be published. Required fields are marked *