In a spreadsheet you are given seventyfive data in column A

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

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

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 crea

In a spreadsheet you are given seventyfive data in column A

Solution

Get Help Now

Submit a Take Down Notice