Question

In: Statistics and Probability

I have the following data for a sample of 97 observations: 7.541026821 8.926230102 10.66501886 10.70044938 7.956283275...

I have the following data for a sample of 97 observations:

7.541026821
8.926230102
10.66501886
10.70044938
7.956283275
10.61170212
9.013674877
7.457787808
8.688519181
9.632112384
9.585695504
9.661098603
7.987363009
10.64290021
9.985713946
9.352236341
9.394775142
6.663463744
9.505301628
8.041563811
9.906639101
10.21807709
10.23849978
10.64519906
9.375470888
9.28112392
8.924667301
10.13189828
8.922899661
10.56735151
10.52283869
10.67374994
8.259466163
10.10803962
8.862558719
8.399596126
10.03949973
10.6273945
8.563698921
9.13285679
9.621790681
10.71288419
10.33937999
10.43902256
9.060291049
10.4805028
9.341939048
10.39537826
8.042335304
8.448344608
9.99079159
7.821488236
10.10571801
11.38210373
7.370965478
10.26909988
9.720033275
8.416385302
9.119573483
8.848977205
6.975063097
9.135161225
7.683767515
10.71318574
8.410446536
11.04208977
8.401574648
8.966110305
9.341060957
8.752457615
10.0378971
10.15017686
9.809193475
10.06748423
7.262885432
7.682518025
9.464422514
7.309646373
10.17592956
10.22469405
9.401419707
10.36079783
9.151199246
10.68604638
10.90957268
7.448984676
9.541930099
10.29110612
9.284300775
9.834144485
7.220975782
9.048763914
10.51913549
10.84623495
9.850393508
9.776483281
8.242635401
Mean 9.37485914
Median 9.505301628
Minimum 6.663463744
Maximum 11.38210373
Variance 1.199349814
Standard Deviation 1.095148307

I now need to find out the Skewness. However I cannot use Excel's built in functions(=Skew) or Data Tool. How can I write the formula in an Excel cell to find the skewness? I know the result should be -0.52

Solutions

Expert Solution

From the given data

orchestra answered 2 years ago
Next > < Previous

Related Solutions

Consider the following sets of sample data: A: 145, 126, 120, 97, 123, 119, 115, 96,...
Consider the following sets of sample data: A: 145, 126, 120, 97, 123, 119, 115, 96, 134, 125, 96, 125, 145, 106 B: 4.09, 4.49, 4.52, 4.62, 4.15, 2.93, 3.91, 4.88, 4.54, 4.66, 4.44 Step 1 of 2 : For each of the above sets of sample data, calculate the coefficient of variation, CV. Round to one decimal place.
A sample of 34 paired observations generates the following data: d− d − = 0.8 and...
A sample of 34 paired observations generates the following data: d− d − = 0.8 and s2D s D 2 = 4.4. Assume a normal distribution. (You may find it useful to reference the appropriate table: z table or t table) a. Construct the 99% confidence interval for the mean difference μD. (Round intermediate calculations to at least 4 decimal places and final answers to 2 decimal places.) b. Using the confidence interval, test whether the mean difference differs from...
CO6) What is the 97% confidence interval for a sample of 104 soda cans that have...
CO6) What is the 97% confidence interval for a sample of 104 soda cans that have a mean amount of 15.10 ounces and a population standard deviation of 0.08 ounces? @See text page 301 (15.940, 15.260)   (15.083, 15.117) (15.020, 15.180) (12.033, 12.067)
Suppose you have a sample of 36 observations with the sample mean = 2 and the...
Suppose you have a sample of 36 observations with the sample mean = 2 and the sample standard deviation = 7. Compute the t-statistic corresponding to these values for the null hypothesis that mean = 0. Test two-sided alternative hypothesis that mean 6= 0. Do you reject the null hypothesis at p = 0:05? At p = 0:01? If the sample size is reduced to 25, do you get the same conclusions?
The following is a small data set of 25 observations. I want you to calculate some...
The following is a small data set of 25 observations. I want you to calculate some statistics by hand to cement the class material. You can use the regular formula for the variance or the computational formula - I’m just interested in the correct result. If you use the computational formula, you will want to calculate a separate row of each value squared in order to calculate the Sum(x^2). Excel can be used to solve this problem. VarX 44 34...
The following is a small data set of 25 observations. I want you to calculate some...
The following is a small data set of 25 observations. I want you to calculate some statistics by hand to cement the class material. You can use the regular formula for the variance or the computational formula - I’m just interested in the correct result. If you use the computational formula, you will want to calculate a separate row of each value squared in order to calculate the Sum(x^2). Excel can be used to solve this problem. VarX 44 34...
A random sample of five observations from three normally distributed populations produced the following data:
  A random sample of five observations from three normally distributed populations produced the following data: (You may find it useful to reference the F table.) Treatments A   B   C   24       18       31     26       21       27     19       27       21     24       23       16     30    ...
A sample of 18 observations taken from a normally distributed population produced the following data: 28.5...
A sample of 18 observations taken from a normally distributed population produced the following data: 28.5 27.5 25.3 25.3 31.3 23.3 26.2 24.5 28.3 37.4 23.9 28.8 27.5 25.5 27.1 25.5 22.7 22.7 Round your answers to three decimal places. a. What is the point estimate of μ? x¯=   b. Make a 90% confidence interval for μ. c. What is the margin of error of estimate for μ in part b? E=
The following sample observations were randomly selected:
The following sample observations were randomly selected:12345X:213832Y:18132249            a. Not available in Connect.b. Determine the regression equation.(Negative answer should be indicated by a minus sign. Do not round intermediate calculations. Round the final answers to 4 decimal places.)                                           b =  a =Y' =  +  X           c. Determine the value of Y' whenX is 11. (Do not round intermediate calculations. Round the final answer to 4 decimal places.)
These data are observations collected using a completely randomized design. Sample 1     Sample 2     Sample 3...
These data are observations collected using a completely randomized design. Sample 1     Sample 2     Sample 3 4 4 2 2 3 0 4 5 2 3 2 1 2 6 (a) Calculate CM and Total SS. (Round your answer for CM to six decimal places and your Total SS to four decimal places. (b) Calculate SST and MST. (Round your answers to four decimal places.) (c) Calculate SSE and MSE. (Round your answers to four decimal places.) (d) Construct an...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT