can you explain how to do these in excel please thank you
The heights of all the students (in centimeters) in stats class is given below as Population X. Use the appropriate Excel functions to get the first three answers. For the last three questions, fill in the table below and use that information to answer the questions. Use AVERAGE to find the mean u of the population. Use VAR. P to find the variance o of the population. Use STDEV.P to find the standard deviation o of the population Use the formula (see your notes) to find the coefficient of variation. Use COUNT function to find the population size (N) The variance of the population (calculate directly from the table) The std dev of the population (calculate directly from the table) Population X (X - H) (X - 1 ) 2 174 9.8696 97.41 162 -2.1304 4.54 159 -5.1304 26.32 175 10.8696 118.15 161 -3.1304 9.80 158 -6.1304 37.58 175 10.8696 118.15 161 -3.1304 9.80 158 -6.1304 37.58 179 14.8696 221.10 166 1.8696 3.50 171 6.8696 47.19 154 -10.1304 102.63 165 0.8696 0.76 170 5.8696 34.45 157 -7.1304 50.84 178 13.8696 192.36 168 3.8696 14.97 152 -12.1304 147.15 142 -22.1304 489.76 160 -4.1304 17.06 180 15.8696 251.84 150 -14.1304 199.67 Total 164.1304 0.0000 2232.6087At a public survey, people were asked to grade the performance of a popular online shopping company. The scores received (out of 100) are as follows. Name the range as Scores. Use the COUNTIES function on the named range to count the categories of responses. Then plot a bar chart (frequency) and a pie chart (Relative frequency). Provide proper captions and labels (like Response Distribution). Search the web on how to use COUNTIFS function if in doubt. Scores Response Frequency Relative Frequency Between Highly Highly 84 90 100 Positive Positive 99 Positive Positive 80 89 99 Neutral Neutral 70 79 87 Average Average 60 69 95 Negative Negative 0 59 66 Total 93 Use SKEW to calculate the Skewness of the scores Select -1 if responses are skewed to the left, 0 if no skew, and 1 if skewed to 65 the right 69 90 Pie Chart (show data) 80 79 86 99 86 44 100 67 75 64 60 63 97 77 90 90 66 37 57 Bar Chart (show data) 99The time (in seconds) spent by customers in the billing queues at V-Mart is given below. Use these numbers to answer the following questions. (Note: Do not sort the numbers.) If possible, plot a Boxplot using Excel and show data points including the outliers. Use COUNTIF function to find the total number of outliers. Times Use Box plot to find the outliers 125 Mean time (AVERAGE) = 128 Median (MEDIAN) time = 108 Largest (MAX) = 145 Smallest (MIN) = 108 25th PERCENTILE = 107 75th PERCENTILE = 120 Inter Quartile Range (IQR) = 139 1.5 x IQR = 125 Use the above calculations and MAX / MIN / COUNTIF 114 functions to calculate the whiskers & number of outlier 146 Left whisker (Lower cut-off point) 186 Right Whisker (Upper cut-off point) 114 Total number of Outliers 164 146 104 130 139 Now use the 3-sigma approach to do the same 114 104 What is o (std dev)? 132 What is the 3-sigma lower cut-off point? 137 what is the 3-sigma upper cut-off point? 108 Total number of Outliers 105 144 112 126 What do you think of the two sets of the cut-off points? 119 114 104 132A medical statistician wanted to examine the relationship between the amount of UV's (x) and incidence of skin cancer (y). As an experiment he found the number of skin cancers detected per 100,000 of population and the average daily sunshine in 12 states around the country. Use this data given below to answer the following questions(including graph). State Average daily Skin cancer pe UV's (x) 100,000 (y) X-ulx y-My ( X-Hx) (y-My) Covariance formula 1 11 W N 6 E(X, - Hx ) (Y: -My) 12 OXY 8 15 n 10 Correlation formula Oxy P= Total Mean Hx (AVERAGE) = Median (X) (MEDIAN) = Standard deviation ox (STDEV.P) = Coefficient of Variation (X) = Mean My (AVERAGE)= Median (Y) (MEDIAN) = Standard deviation oy (STDEV.P) = Coefficient of Variation (Y) = Covariance (COVAR) = Correlation p (CORREL) = Covariance (calculated from the formula) = Correlation(calculated from the formula) = Would you say that daily sunshine affects the incidence of skin cancer? Explain. Draw a scatter diagram in the box below with avg. daily UV's on the x-axis and skin cancer rate per 100,000 on the y-axis. Label the title and Axes properly. Show the trend line (regression line) and the data labels. Format the two axes properly to have the origin at (2,2) instead of the default (0,0)
