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
orchestra answered 3 years agoRelated Solutions
The data for a random sample of 10 paired observations are shown in the following table....
The data for a random sample of 10 paired observations are shown
in the following table.
Pair
Population1
Population 2
1
19
24
2
25
27
3
31
36
4
52
53
5
49
55
6
34
34
7
59
66
8
47
51
9
17
20
10
51
55
If you wish to test whether these data are sufficient to
indicate that the mean for population 2 is larger than that for
population 1, what are the appropriate null...
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.)
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Which of the following is not an advantage of decentralization? Lower level managers are trained for...
- 1. A mole of X reacts at a constant pressure of 43.0 atm via the reaction...
- Why was the U.S. trying to spread our influence to other nations? Could we have still...
- For the past several weeks you have addressed several different areas of telecommunications and information technology...
- Draw the structure of a compound with molecular formula C5H12 that exhibits only one kind of...
- (1) Discuss your reaction to Hitler's Degenerate Art Show. Is it ever justified for a government...
- The probability of success is 0.68. A sample of 15 is taken. Assume independent trials. (Please...
ADVERTISEMENT