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 frequencyMake a cumulative relative frequency ogiveDon’t forget descriptive title and labels on x and y axis (ogive is not descriptive, what does the graph represent?)Make a frequency polygonDon’t forget a descriptive title and labels on x and y axis (polygon is not descriptive, what does the graph represent?)Calculate the meanCalculate the medianCalculate the sample standard deviation (our data is sample from our class, not a population!)Calculate the Q1 and Q3 values AВCEFGHKMNPQR1 AgeGenderFor the following questions, use only the "age" column:Help for this spreadsheet24 M323 МPointsAge Frequency Distribution:Class WidthReview 2.2, 3.1 – 3.3 of your text. Also watch420 F527 MClass LimitsRelativeCumulativeExcel Videos in BlackBoard.640 FLowHighMidpointFreq.FrequencyRelative Freg• Your data is already copied into columns A724 FLimits2and B.820 FFreq.2Only cells in yellow need to be completed.• Choose a class width according to thefollowing equation (rounded up to wholenumber):CLASS WIDTH = (MAX VALUE - MIN VALUE)/#of Classes (5)• The ogive and polygon graphs need to be943 МMid.21021 FRF21132 FCF11221 M1330 F2Mean*Round to two decimals1436 F2Median*Round to one decimal1519 M2Sample Standard deviation:*Round to two decimals1638 M2Q1*Round to one decimalincluded on this page under the headersbelow. Please do not put them on a separate1732 М2Q3*Round to one decimal1822 M1921 F2020 FOgive:Polygon3Ogive:Polygon:2119 M32230 F2320 M2425Total:2526

Descriptive statistics are summary statistics which are used to quantitatively summarize the given…

Answered: or this part of the project, you will…

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Related questions

Question

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
- 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
- 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