In a spreadsheet you are given seventy-five data in column A. In D1:D4 give the
ID: 3442188 • Letter: I
Question
In a spreadsheet you are given seventy-five data in column A. In D1:D4 give the mean, standard deviation, skewness, and kurtosis of the data set. In F2:F12 create bins with values 0, 1, ..., 10. In G2:G12 give the frequencies of the bins. The total should appear in G13. Use the bin data to create a dependency graph (line chart) with the bin value on the horizontal axis and the height being the frequency, and place this chart in C16:H30.
here are the data
I wonder if i need to use commander or do some kind of calculation to find the answer. I know that bins are 0 1 2 3 4 5 6 7 8 and 9. freq I need a commander from Cell A1:A75
Explanation / Answer
We are given the data of 75 observations.
And using EXCEL we have to find mean,standard deviation,skewness and kurtosis of the following data also we have to make a table of observation and their corresponding frequency and draw the line chart .
Now EXCEL command for all these are,
Mean = AVERAGE(data)
ST DEV = STDEV(data)
Skewness = SKEW(data)
Kurtosis = KURT(data)
To find frequency we have to arrange data in ascending order.
and then use the command as COUNT(data) (data values are like 0,1,2,3,....,9)
And for the data we have to draw a line chart in EXCEL command as select all the data INSERT =>LINE CHART=> => ok
The output is as follows,
Doesn't copy the graph.
sorry for inconvinience.
value ascending order 6 1 8 1 3 1 5 2 8 2 6 2 4 2 5 2 7 3 4 3 9 3 5 3 4 3 5 3 7 3 3 3 7 3 1 3 5 4 6 4 1 4 2 4 6 4 7 4 6 4 4 4 4 4 7 5 8 5 8 5 5 5 4 5 6 5 3 5 7 5 8 5 7 5 8 5 7 5 3 5 6 5 3 6 6 6 7 6 5 6 5 6 4 6 6 6 1 6 9 6 8 6 2 6 5 7 3 7 5 7 8 7 5 7 2 7 4 7 8 7 3 7 4 7 7 7 3 8 7 8 6 8 2 8 5 8 5 8 5 8 3 8 9 8 2 9 6 9 3 9