Open the DATA file, in the PAGE1, calculate the mean, variance and standard devi- ation (All...

Question

Question

Open the DATA file, in the PAGE1, calculate the mean, variance and standard devi-
ation (All your formulas should be visible).

1 VALUE MEAN VARIANCE STDEV 48 7O 51 60 45 62 40 85 65 23 PAGE1 ▼ PAGE2

math Statistics-And-Probability

Answer 1

Answer #1

MEAN=AVERAGE(A2:A13)

=

56.08333

VARIANCE=VAR.S(A2:A13)

=

81.90152

STDDEV=STDEV.S(A2:A13)

=

9.049946

THEREFORE

MEAN	VARIANCE	STDDEV
56.08333	81.90152	9.049946

Answer 2

Similar Homework Help Questions

Calculate the range, mean, mode, median, Standard deviation Calculate the skewness and kurtosis for the above...

Calculate the range, mean, mode, median, Standard deviation Calculate the skewness and kurtosis for the above data and interpret the data. The following is data collected from the daily salary employees of ZZ COMPANY.. 68 19 43 11 37 30 19 67 65 34 96 23 93 73 46 39 21 12 89 52 33 21 18 57 80 56 91 62 56 48 84 23 78 96 49 36 90 42 65 15 43 36 65 59 34 71...
Question 9 1 pts Calculate sample variance for the following data collection: 10, 25, 28, 35...

Question 9 1 pts Calculate sample variance for the following data collection: 10, 25, 28, 35 (when you calculate variance, divide by N-1 not by O 85 O 150 O 180 Question 8 1 pts Based on this Histogram, what percentage of data are below 41? 8 6 2 11-20 21-30 31-40 41-50 51-60 o 40% O 5096 65% 7596
For each variable of interest, do the following: 1. Find the mean, five-number summary, range, variance,...

For each variable of interest, do the following: 1. Find the mean, five-number summary, range, variance, and standard deviation. Display these numbers in a format that is easy to understand. 2. For each variable of interest, use its five-number summary to construct a boxplot. Each boxplot must be constructed horizontally, and must be accompanied by a brief descriptive paragraph that assesses whether the data appear to be symmetrical, left-skewed, or right-skewed. Construct a 95% confidence interval for the mean μ...

A new hotel will open its doors in a certain city. Before deciding the price of...

A new hotel will open its doors in a certain city. Before deciding the price of their rooms, the manager investigates the prices per room of 40 hotels of the same category (2 star Hotels). The data obtained were: 39 47 37 56 43 49 50 61 51 45 53 39 43 50 60 47 51 42 44 58 33 43 21 58 44 38 61 43 53 45 40 54 39 47 33 45 47 42 45 88 Calculate...
This is stat question and the data show as below This is stat question and the...

This is stat question and the data show as below This is stat question and the data show as below Flows in the Credit River in Mississauga are given in the file 'credit.MPJ' or in the file 'credit.xlsx'. C1 C2 Feb C3 C4 C5 April Lu 36 260 95 72 327 184 154 58 178 205 335 101 62 294 250 92 87 64 87 224 69 129 95 238 127 163 239 124 17 18 19 20 21 61...
Calculate the mean, the variance, and the standard deviation of the following discrete probability distribution

Calculate the mean, the variance, and the standard deviation of the following discrete probability distribution. (Negative values should be indicated by a minus sign. Round intermediate calculations to at least 4 decimal places. Round your final answers to 2 decimal places.)$$ \begin{array}{lrrrr} x & -23 & -17 & -9 & -3 \\ P(x=x) & 0.50 & 0.25 & 0.15 & 0.10 \end{array} $$Mean:Variance:Standard Deviation:

This data is from a sample. Calculate the mean, standard deviation, and variance. Suggestion: use technology....

This data is from a sample. Calculate the mean, standard deviation, and variance. Suggestion: use technology. Roi mswers to two decimal places. 39.4 31.4 10.6 29.7 26.9 29.3 32.7 Mean = Standard Deviation = Variance = Ooops - now you discover that the data was actually from a population! So now you must give the population standard deviation Population Standard Deviation
In a d stribution where the mean 60 and the standard deviation is 3 find the...

In a d stribution where the mean 60 and the standard deviation is 3 find the largest fraction of the numbers that could meet the following requirements of the numbers in the distribution, the fraction that is less than 45 or more than 75 is at most (Type an integer or simplitied fraction ) LI ess than 45 or more than 75 58 61 63 56 55 50 56 62 54 scores of the 54 members of a sociology lecture...
(9 marks) 6) The data below shows the mass of 40 students in class. The measurement...

(9 marks) 6) The data below shows the mass of 40 students in class. The measurement is the nearest kg. 55 70 57 73 55 64 60 48 59 72 58 54 69 51 63 78 75 64 65 57 71 78 76 62 66 62 61 53 67 49 76 63 63 76 52 76 71 61 56 71 A) Construct a frequency distribution table with 7 classes for the data given above? B) Draw the histogram for the...

4- Variance and Standard deviation (how far the data values lie from the mean) The mean,...

4- Variance and Standard deviation (how far the data values lie from the mean) The mean, mode, and median do a nice job in telling where the center of the data set is, but often we are interested in more. For example, a pharmaceutical engineer develops a new drug that regulates iron in the blood. Suppose she finds out that the average sugar content after taking the medication is the optimal level. This does not mean that the drug is...