Can someone asnwer pelase? For questions 10-12, use the following dataset, speci
ID: 3297430 • Letter: C
Question
Can someone asnwer pelase?
For questions 10-12, use the following dataset, specifically the variable Credit Hours Taken.
10) Create a frequency table, include relative frequency and cumulative frequency.
Credit Hours
Frequency
Relative Frequency
Cumulative Frequency
11) Identify what type of chart would be best to display this data, then create that chart.
12) Make a statement about the shape of the graph, and what we can tell about credit hours students are taking.
Credit Hours
Frequency
Relative Frequency
Cumulative Frequency
Credit Hours Taken 18 15 19 21 18 12 20 21 12 16 Works Full Time Final Percent 85.6% 96.2% 71.8% 64% 88.2% 91.3% 75.2% 81% 84% 95.3% Final Grade Student Matt Patricia Bob Josh Sarah Logan Adam Emil Sherri AnnaExplanation / Answer
10) For creating a frequency table, first we have to decide the class intervals. For this we need to look at the data and decide based on the spread of the data.
In the case of credit hours the minimum is 12 and maximum is 21.and no of observations is 10. Hence we suggest the 6 Class Intervals: <=11, 12-14, 15-17, 18-20, 21-23, >=24.
The frequency, cumulative frequency and relative frequency are computed and shown in the table below. Cumulative Frequency for a Class is calculated as the total count of all observations <= the Class Upper Limit. Relative Frequency is calculated as the total count of observations in that class divided by the total count of all observations, expressed as a percentage.
C. I. Frequency Cum. Freq. Rel. Freq.%
<=11 0 0 0
12-14 2 2 20
15-17 2 4 20
18-20 4 8 40
21-23 2 10 20
>= 24 0 10 0
Total 10 10 100
11) A Histogram will be the best Chart to display this data.
12) The shape of the graph can be approximated to a bell-shaped curve. Hence the Credit Hours Students are taking approximates a Normal Distribution.