Notes: 1. This homework is to be done individually. 2. Before doing the first problem, do the practice problem posted under Apply and Discover 1.1 3. Before doing the second problem, do the practice problem posted under Apply and Discover 1.2. 4. Word-process your assignment within this template. Do not create a new file. Problem 1: Using Symbols Word-process the symbol for population standard deviation (sigma) in the space below: Using Subscripts Word-process the symbol for population standard deviation with subscript x (sigma subscript x) in the space below: Using Equations Word-process the equations provided in the space below using the Equation tab under the Insert menu: Using Drawing Tool to Create Diagrams Create the normal curve as shown below using the Illustration tool under the Insert menu. Problem 2: Descriptive Statistics The monthly average low temperatures* during different months of year at Manchester, NH are given below: January February March April May June 5 8 18 29 40 50 July August September October November December 55 53 44 32 24 12 Source: www.weather.com Word-process your solutions and answers below. Copy and paste your Excel work under the appropriate question below. Expand the space as necessary. a) Find the mean yearly low temperature based on the monthly averages by applying the formulas (without using computer software). b) Find the standard deviation of the monthly low temperatures by applying the formulas (without using computer software). c) If the above data was a sample, what would be the sample standard deviation? Compute by applying the formulas (without using computer software). d) Copy and paste the data from this document to Excel. Use functions in Excel to compute the mean, population standard deviation and sample standard deviation. Copy and paste your spreadsheet work into this Word document. e) Create a histogram using MS Excel. Comment on the distribution of monthly low temperatures. Copy and paste your spreadsheet work into this Word document. Hint: use 9, 19, 29, 39, 49, 59 for the bins.
Paper#13481 | Written in 18-Jul-2015Price : $25