(Solved): Project: Part 2 Descriptive Statistics Assignment For this part of the project, you will calcula ...

Project: Part 2 – Descriptive Statistics Assignment
For this part of the project, you will calculate descriptive statistics for the first question, age,
using the Excel spreadsheet your instructor will send with all the class data at the end of Module
2.
This sheet will also provide space for you to do the following descriptive statistics under the
“Module 3” tab:
You will submit the Excel sheet with the following information:
? Make a Frequency Distribution with 5 classes, also list the midpoints, relative
frequency, and cumulative relative frequency
? Make a cumulative relative frequency ogive
o Don’t forget descriptive title and labels on x and y axis (ogive is not
descriptive, what does the graph represent?)
? Make a frequency polygon
o Don’t forget a descriptive title and labels on x and y axis (polygon is not
descriptive, what does the graph represent?)
? Calculate the mean
? Calculate the median
? Calculate the sample standard deviation (our data is sample from our class, not a
population!)
? Calculate the Q1 and Q3 values

 

Lu Project: Part 5 - Final Report X Lu Project Assignment Instruction xb Answered: or this part of the pix X 8 week Data File for Project - B X ? ? ? Dashboard * Office Editing for Docs, Sheets & Slides | chrome-extension://bpmcpldpdmajfigpchkicefoigmkfalc/views/app.html Bb Blackboard Bb My Courses W Abbys Office 365 Google Docs Mail - Mohler, Abiga... Mabbyj.mohler@gm... 8 week Data File for Project - B09 (2).xlsx File Edit Insert Format Help Q Q Calibri X fx 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 67892 16 17 18 19 20 21 22 K Week 3 A Age B Gender 39 M 43 M 23 F 30 M 17 M 18 M 62 M 23 M 29 M 16 F 17 M 17 F 33 F 23 M 16 F 26 F 17 F 32 F 26 M 24 F 31 F Week 5 ? Week 6 D Limits Freq. Mid. RF CF Ogive: Polygon Project Help 11 ? E NNNO 2 Points Age Frequency Distribution: 2 2 2 1 2 2 2 2 2 3 ? 3 BIUS A I J K F G For the following questions, use only the "age" column: Q1 Q3 Class Limits Low H 188 Mean Median Sample Standard deviation: Relative Cumulative High Midpoint Freq. Frequency Relative Freq *Round to two decimals *Round to one decimal Class Width Ogive: *Round to one decimal *Round to one decimal O *Round to two decimals Google Docs MindTap-Cengage... L C Get Homework Help With Che x + M N Polygon: O LU P Ly Dashboard Q á Shared - Dropbox Download R S ? 1 Share T X ? ? U ? 1:59