# Statistics exam help

## Instructions

Name: | |||||||

Problem # | Point Value | Your Points | |||||

1 | 3 | ||||||

2 | 3 | ||||||

3 | 1 | ||||||

4 | 1 | ||||||

5 | 1 | ||||||

6 | 1 | ||||||

7 | 1 | ||||||

8 | 1 | ||||||

9 | 1 | ||||||

10 | 1 | ||||||

11 | 1 | ||||||

12 | 1 | ||||||

13 | 1 | ||||||

14 | 4 | ||||||

15 | 1 | ||||||

16 | 1 | ||||||

17 | 6 | ||||||

18 | 1 | ||||||

19 | 1 | ||||||

20 | 3 | ||||||

21 | 1 | ||||||

22 | 1 | ||||||

23 | 2 | ||||||

24 | 1 | ||||||

25 | 1 | ||||||

26 | 1 | ||||||

27 | 9 | ||||||

28 | 15 | ||||||

29 | 20 | ||||||

30 | 15 | ||||||

Sum | 100 | 0 |

Final Exam – MGMT 650 Fall 2016 Directions: Please answer all questions. There are 30 questions and the exam is worth 20% of your total grade. The questions are not equally weighted. The point value for each question is listed below (100 points total). Data needed to complete the exam are contained in this Excel file. All answers are to be contained in one excel file. You can save this file under your name and complete the work within this file. Please do not delete this tab, the instructions tab. This is an open book, open notes exam. The one limitation is that you may NOT work with other people. This test must be completed independently. Show your work to gain partial credit. Be sure your name is on your document. Good luck!

## Q1 through 13

The 13 questions on this page are multiple choice. Please enter your answers into column M in the shaded box. | ||||||||||||||

Your Answer to Q1: | Total Points = | |||||||||||||

Your Answer to Q2 #1 | Total Points = | |||||||||||||

Your Answer to Q2 #2 | ||||||||||||||

Your Answer to Q2 #3 | ||||||||||||||

Your Answer to Q3 #1: | Total Points = | |||||||||||||

Your Answer to Q4: | Total Points = | |||||||||||||

Your Answer to Q5: | Total Points = | |||||||||||||

Your Answer to Q6: | Total Points = | |||||||||||||

Your Answer to Q7: | Total Points = | |||||||||||||

Your Answer to Q8: | Total Points = | |||||||||||||

Your Answer to Q9: | Total Points = | |||||||||||||

Your Answer to Q10: | Total Points = | |||||||||||||

Your Answer to Q11: | Total Points = | |||||||||||||

Your Answer to Q12: | Total Points = | |||||||||||||

Your Answer to Q13: | Total Points = | |||||||||||||

Total | 0 |

Q5. The two most important aspects of precision are reliability and validity. Validity refers to __________ A. “….the agreement between the value of a measurement and its true value.” B. “….the reproducibility of a measurement.”

Q4. Let’s assume we know that 1% of women over the age of 40 have breast cancer. Let’s assume that 90% of women who have breast cancer will test positive for breast cancer in a mammogram. Eight percent of women that do NOT have breast cancer will also test positive. What is the probability of having cancer if you have a positive test (Select the correct answer from the choices below.) A. 0.90 B. 0.01 C. 0.10 D. 0.08

Q2: Match the appropriate inferential statistical test to the provided definitions.

A. t test B. ANOVA C. Chi-Square

1. Used to test independence for more than 2 means (i.e. compares the means of more than 2 groups) Letter: _______ 2. Used to test the independence between 2 or more categorical variables Letter: _______ 3. Used to compare means of 2 groups Letter: _______

Q3: What is the risk of performing the t=test using pooled variance, if the variances between the 2 samples are actually unequal (i.e.. fail the F test) ? A. Your result will only be applicable for a one-tail t-test B. You will fail to adjust for sample size. C. You may falsely accept or reject the null hypothesis.

Q1. Central tendency is most commonly referred to as the numberical center of the data set: Which of these are common representations of central tendency A. Mean B. Variance C. Mode D. Median E. Range F. Standard Deviation

Q6. According to the empirical rule, if the data form a “bell-shaped curve” (normal distribution), approximately what percent of the observations will be contained within + /- 2 standard deviations from the arithmetic mean. (Select the correct answer from the choices below.) A. 99.7 B. 95.0 C. 75.0 D. 68.3

Q7. A new drug is created to help people with depression. When testing the drug, what are the null and alternative hypotheses? A. Ho: As a result of 300mg./day of the ABC drug, there will be no significant difference in depression. HA: As a result of 300mg/day of the ABC drug, there will be a significant difference in depression. B. Ho: As a result of 300mg./day of the ABC drug, there will be a significant difference in depression. HA: As a result of 300mg/day of the ABC drug, there will be no significant difference in depression.

Q8. The data are the areas of lawns in square feet. You sample five houses. The areas of the lawns are 144 sq. feet, 160 sq. feet, 190 sq. feet, 180 sq. feet, and 210 sq. feet. What type of data is this? A. Quantitative continuous data B. Quantitative discrete data C. Qualitative data D. Binomial Distribution data

Q9. During an election year, we see articles in the newspaper that state confidence intervals in terms of proportions or percentages. For example, a poll for a particular candidate running for president might show that the candidate has 40% of the vote within 3 percentage points. This election polls was calculated with 95% confidence. Is there a 40% chance that this candidate will be elected? A) Yes, and we are 90% sure of it. B) Yes, and we are 95% sure of it. C) We are 95% sure that the chance this candidate will be elected is between 37% and 43% D) Maybe. 40% is a believable value of the proportion based on the information given. E) No. The proportion is 43%. F) No, and we are 90% sure of it. G) No, and we are 95% sure of it.

Q10. This question is related to simple linear regression. In simple linear regression, the goal is to determine if there is a linear change in the _______ variable based on a change in the ______ variable. The dependent variable will always be a ________ variable. If a negative relationship is found, this means that as the independent variable _______, the dependent variable _______. (Select the correct answer from the choices below to correctly fill in the blank words.) A. dependent, independent, categorical, increases, decreases B. independent, dependent, categorical, increases, decreases C. dependent, independent, numerical, increases, decreases D. dependent, independent, numerical, increases, increases E. independent, dependent, numerical, decreases, increases

Q11. What is the function in Excel used to find the mean? A. =MEAN() B. =AVERAGE()

Q12. What is the algebraic equation for the coefficient of variation? A. Variance / mean B. Variance * mean C. Standard deviation / mean D. Standard deviation * mean

Q13. If you toss a die twice, what is the sample space if you want to restrict the results to only the ones where adding the results of the two throws together equals seven? For example, if you get 1 on the first toss and 6 on the second toss these two tosses meet the criteria. A. S = {(1,6), (2,5), (3,4)} B. S = {(1,6), (2,5), (3,4), (4,3), (5,2), (6,1)} C. S = {7} D. S = {2,5), (5,2), (1,6), (6,1)} E. S = (1,6), (2,5), (3,4)

## Q14 through 26

The 13 questions on this page are multiple choice. Please enter your answers into column M in the shaded box. | ||||||||||||||

Your Answer to Q14: | Total Points = | |||||||||||||

Your Answer to Q15: | Total Points = | |||||||||||||

Your Answer to Q16: | Total Points = | |||||||||||||

Your Answer to Q16: | Total Points = | |||||||||||||

Your Answer to Q18: | Total Points = | |||||||||||||

Your Answer to Q19: | Total Points = | |||||||||||||

Your Answer to Q20: | Total Points = | |||||||||||||

Graduated | Did not Graduate | Total | ||||||||||||

Experimental | 85 | |||||||||||||

Control | 82 | |||||||||||||

Total | 116 | 51 | 167 | |||||||||||

A. | Graduated | Did not Graduate | Total | |||||||||||

Experimental | 73 | 12 | 85 | |||||||||||

Control | 43 | 39 | 82 | |||||||||||

Total | 116 | 51 | 167 | |||||||||||

B. | Graduated | Did not Graduate | Total | |||||||||||

Experimental | 59 | 26 | 85 | |||||||||||

Control | 57 | 25 | 82 | |||||||||||

Total | 116 | 51 | 167 | |||||||||||

Your Answer to Q21: | Total Points = | |||||||||||||

Your Answer to Q22: | Total Points = | |||||||||||||

Your Answer to Q23: | Total Points = | |||||||||||||

Your Answer to Q24: | Total Points = | |||||||||||||

Your Answer to Q25: | Total Points = | |||||||||||||

Your Answer to Q26: | Total Points = | |||||||||||||

Total | 0 |

Q14: Choose all answers that describe an array function in Excel. A. Uses curly braces B. Uses parentheses C. Elements in a vertical array are separated by commas D. Elements in a vertical array are separated by semicolons E. You must use other computer keys besides return to create the function F. One array function is =FREQUENCY() G. One array function is =STDEV.P()

Q15: The probability that you will throw boxcars (two 6’s) with one throw using 2 dice is A. .028 B. .17 C. .33

Q16: Suppose that a 90% confidence interval states that the population mean is greater than 100 and less than 200. How would you interpret this statement? A. We are 90% sure that the population mean is less than 200. B. We would expect 90% of the interval estimates to include the population parameter.

Q17: Whch statistics distributions are based on the normal curve? Choose all that apply. A. Student’s t distribution B. Chi Square distribution C. Monica’s Z distribution D. F distribution E. G distribution

Q18: Which one is correct for bivariate data? A. If the measurements are categorical (e.g. Yes or No to the question “Do you smoke?”) and taken from two distinct group (e.g. Female, Male) the analysis will involve comparing two independent means. B. If the measurements are quantitative (e.g. GPA) and taken from two distinct groups (e.g. Graduate, Undergraduate) the analysis will involve comparing two independent proportions. C. If the measurements are quantitative (e.g. Weight) and taken twice from each subject (e.g. subject’s weight before and after dieting) the analysis will involve comparing two dependent means.

Q19: What is the null hypothesis that ANOVA tests? A. H(0): All the population means are equal B. H(0): There is a difference between the means of the populations

Q20: Given the following totals column, what are the esxpected values, assuming homogeneity or independence.?

Q21: Which of the following are functions with x denoting the independent variable and y denoting the dependent variable? Choose all that apply. A. y = f(x) B. x = f(y) C. y = a + bx

Q22: A car dealer measures the number of cars sold by each salesperson in January. This data is: A. Time series B. Cross sectional C. Numerical D. Categorical

Q23: Which statement(s) is/are false about the Chi Square distribution? A. As the degrees of freedom increases, the Chi Square distribution approaches a normal distribution. B. The chi-square distribution is always right skewed, regardless of the value of the degrees of freedom parameter. C. The chi-square statistic is always positive. D. As the degrees of freedom increases, the shape of the chi-square distribution becomes more skewed.

Q24: Which of the following is a paired sample? A. Ten pairs of data were taken measuring zinc concentration in bottom water and surface water. B. Randomly select 20 males and 20 females and compare the average time they spend watching TV.

Q25: In statistics, what does MSE stand for? A. Mean-Square Error B. Multiple-Square Error C. Mean-statistical Error D. Multiple-statistical Error

Q26: A UMUC professor wants to determine if her students are getting taller. She obtains the height of 50 of her students over the years. What is the df? A. 51 B. 50 C. 49 D. 100 E. 98

## Q27

Person | Waiting Time | |||

1 | 35 | |||

2 | 25 | |||

3 | 40 | |||

4 | 51 | |||

5 | 52 | |||

6 | 55 | |||

7 | 16 | |||

8 | 36 | |||

9 | 49 | |||

10 | 27 | |||

11 | 31 | A) | Show your Bins here: | |

12 | 21 | Wait times in Mins. | Number of customers | |

13 | 20 | |||

14 | 28 | |||

15 | 30 | |||

16 | 15 | |||

17 | 32 | |||

18 | 34 | |||

19 | 39 | |||

20 | 34 | |||

21 | 35 | |||

22 | 34 | |||

23 | 13 | |||

24 | 37 | |||

25 | 36 | Total | ||

26 | 33 | |||

27 | 55 | |||

28 | 70 | B) | Show your graph of the frequency distribution here. | |

29 | 47 | |||

30 | 62 | |||

31 | 31 | |||

32 | 55 | |||

33 | 22 | |||

34 | 43 | |||

35 | 47 | |||

36 | 57 | |||

37 | 37 | |||

38 | 33 | |||

39 | 45 | |||

40 | 47 | |||

41 | 46 | |||

42 | 14 | |||

43 | 30 | |||

44 | 23 | |||

45 | 34 | |||

46 | 38 | |||

47 | 38 | |||

48 | 35 | |||

49 | 60 | |||

50 | 21 | C) | P (A) | |

51 | 29 | |||

52 | 12 | |||

53 | 52 | |||

54 | 25 | |||

55 | 31 | |||

56 | 46 | |||

57 | 43 | |||

58 | 47 | |||

59 | 44 | |||

60 | 24 | |||

61 | 27 | |||

62 | 45 | |||

63 | 41 | |||

64 | 29 | |||

65 | 36 | |||

66 | 39 | |||

67 | 44 | |||

68 | 41 | |||

69 | 29 | |||

70 | 57 | |||

71 | 43 | |||

72 | 39 | |||

73 | 46 | |||

74 | 47 | |||

75 | 32 | |||

76 | 29 | |||

77 | 49 | |||

78 | 26 | |||

79 | 22 | |||

80 | 45 | |||

81 | 44 | |||

82 | 60 | |||

83 | 52 | |||

84 | 51 | |||

85 | 39 | |||

86 | 38 | |||

87 | 43 | |||

88 | 38 | |||

89 | 27 | |||

90 | 20 | |||

91 | 46 | |||

92 | 42 | |||

93 | 44 | |||

94 | 40 | |||

95 | 28 | |||

96 | 26 | |||

97 | 35 | |||

98 | 30 | |||

99 | 30 | |||

100 | 34 | |||

101 | 33 | |||

102 | 33 | |||

103 | 46 | |||

104 | 43 | |||

105 | 32 | |||

106 | 51 | |||

107 | 20 | |||

108 | 44 | |||

109 | 37 | |||

110 | 38 | |||

111 | 31 | |||

112 | 33 | |||

113 | 46 | |||

114 | 49 | |||

115 | 43 | |||

116 | 45 | |||

117 | 54 | |||

118 | 41 | |||

119 | 44 | |||

120 | 57 | |||

121 | 35 | |||

122 | 48 | |||

123 | 39 | |||

124 | 49 | |||

125 | 37 | |||

126 | 30 | |||

127 | 49 | |||

128 | 32 | |||

129 | 43 | |||

130 | 43 | |||

131 | 35 | |||

132 | 34 | |||

133 | 24 | |||

134 | 58 | |||

135 | 32 | |||

136 | 39 | |||

137 | 36 | |||

138 | 66 | |||

139 | 51 | |||

140 | 47 | |||

141 | 51 | |||

142 | 40 | |||

143 | 43 | |||

144 | 36 | |||

145 | 26 | |||

146 | 51 | |||

147 | 35 | |||

148 | 25 | |||

149 | 46 | |||

150 | 46 | |||

151 | 42 | |||

152 | 42 | |||

153 | 32 | |||

154 | 45 | |||

155 | 43 | |||

156 | 49 | |||

157 | 10 | |||

158 | 43 | |||

159 | 53 | |||

160 | 21 | |||

161 | 38 | |||

162 | 52 | |||

163 | 55 | |||

164 | 40 | |||

165 | 39 | |||

166 | 57 | |||

167 | 38 | |||

168 | 31 | |||

169 | 47 | |||

170 | 38 | |||

171 | 48 | |||

172 | 42 | |||

173 | 53 | |||

174 | 37 | |||

175 | 28 | |||

176 | 23 | |||

177 | 12 | |||

178 | 39 | |||

179 | 41 | |||

180 | 38 | |||

181 | 40 | |||

182 | 41 | |||

183 | 53 | |||

184 | 39 | |||

185 | 27 | |||

186 | 24 | |||

187 | 40 | |||

188 | 48 | |||

189 | 23 | |||

190 | 32 | |||

191 | 43 | |||

192 | 36 | |||

193 | 35 | |||

194 | 36 | |||

195 | 34 | |||

196 | 30 | |||

197 | 44 | |||

198 | 39 | |||

199 | 51 | |||

200 | 41 |

Q27. The wait times for an oil change are given in columns A and B. A. Generate a frequency distribution of 10 Bins for wait times for an oil change. Use the =MIN() , =MAX(), and =FREQUENCY() functions. B.Make sure the graph includes a title. Label the x and y axis. C. Suppose a customer is selected at random. Let A = the event the customer’s wait is less than 16 minutes. Find the probability of A.

## Q28

51 | 53 | 49 | 43 | 47 | |||||

52 | 60 | 30 | 45 | 46 | |||||

a) | |||||||||

B) |

Q28. Find the confidence limit for these values 51, 53, 49, 43, 47, 46, 45, 30, 60, 52. a) Using α = .05, test the hypothesis using the confidence limits that the true mean is 50 against the alternative that the true mean is not 50. Show your work. b) State the conclusion.

## Q29

Q29. Refer to the tab titled “Service Satisfaction” for data required to solve this problem. You are looking at results of a survey of customer satisfaction with their service department from 2 different Car Dealerships. Forty customers from each dealership took a survey related to their satisfaction after getting their brakes cleaned and serviced. The survey results were calculated on a scale from 0 to 10, with 10 indicating complete satisfaction. The Dealerships are titled Dealership A and Dealership B. You want to know if customer satisfaction in the service department was the same or different based on the dealership. Answer questions 1 through 3 below.

#1. What is your null hypothesis (H0) for this research topic? (Select either A or B from below.) A. Customer satisfaction is dependent on which dealership did the brake work. B. There is no difference in customer satisfaction related to the service experience in Dealership A or Dealership B.

#2. Calculate the mean of the customer satisfaction score for each dealership. A. ______ Dealership A customer satistaction B. ______ Dealership B customer satisfaction

#3. Perform the appropriate statistical test to test for significance between the the two groups. Note, use “data analysis” to get your result. Based on your results: A. What p-value did you find and is this significant? B. Would you accept or reject the null hypothesis?

## Q30

Q30. Refer to the tab titled “Yarn Purchased” for data required to solve this problem. This data represents the number of skeins bought with 4 different colors of the same yarn per customer. Answer questions 1 through 2 below.

#1. What is an appropriate null hypothesis (H0) for this data analysis? A. There is a significant difference in customer color preferences for the yarn. B. There is no difference in color preference for the 4 different colors of yarn.

#2. Perform a one-way ANOVA to test for significant difference in color preference between the 4 colors. Use the data analysis tool to perform the test. You will need to rearange the data to be able to run the test appropriately. You can create a new tab with the data ordered in the way that is required to run this test.) Based on the p-value from your ANOVA test, would you accept or reject your null hypothesis ? Explain why.

## Service Satisfaction

Dealership A | Dealership B |

9.1 | 9.9 |

7.8 | 6.1 |

8.1 | 6.8 |

8.8 | 8.3 |

6.7 | 7.5 |

5.6 | 10.0 |

10.0 | 9.9 |

9.1 | 8.3 |

8.9 | 6.1 |

7.6 | 9.3 |

9.9 | 8.4 |

6.5 | 7.2 |

8.5 | 5.3 |

7.7 | 6.9 |

8.3 | 9.0 |

5.0 | 6.9 |

7.8 | 5.5 |

5.9 | 7.9 |

8.3 | 8.6 |

6.6 | 9.5 |

8.2 | 9.3 |

9.3 | 5.2 |

8.8 | 8.2 |

9.2 | 7.0 |

8.0 | 10.0 |

9.7 | 8.0 |

7.6 | 7.0 |

8.9 | 5.9 |

8.8 | 10.0 |

8.2 | 8.8 |

8.8 | 6.3 |

7.9 | 7.3 |

6.4 | 7.5 |

9.2 | 9.0 |

7.2 | 8.2 |

8.3 | 7.4 |

7.5 | 8.3 |

8.2 | 7.6 |

8.3 | 9.7 |

8.1 | 8.2 |

## Yarn Purchased

Customer | Color of yarn | Number of Skeins purchased |

1 | Blue | 2 |

2 | Blue | 4 |

3 | Blue | 11 |

4 | Blue | 4 |

5 | Blue | 6 |

6 | Blue | 6 |

7 | Blue | 4 |

8 | Blue | 3 |

9 | Blue | 15 |

10 | Blue | 2 |

11 | Blue | 4 |

12 | Blue | 4 |

13 | Blue | 8 |

14 | Blue | 13 |

15 | Blue | 1 |

16 | Blue | 2 |

17 | Blue | 9 |

18 | Blue | 10 |

19 | Green | 6 |

20 | Green | 7 |

21 | Green | 6 |

22 | Green | 12 |

23 | Green | 14 |

24 | Green | 6 |

25 | Green | 7 |

26 | Green | 8 |

27 | Green | 19 |

28 | Green | 7 |

29 | Green | 7 |

30 | Green | 1 |

31 | Green | 7 |

32 | Green | 21 |

33 | Green | 5 |

34 | Green | 3 |

35 | Green | 25 |

36 | Green | 5 |

37 | Green | 4 |

38 | Green | 13 |

39 | Green | 2 |

40 | Green | 14 |

41 | Green | 20 |

42 | Green | 3 |

43 | Green | 6 |

44 | Green | 3 |

45 | Green | 7 |

46 | Green | 6 |

47 | Green | 4 |

48 | Green | 4 |

49 | Green | 13 |

50 | Green | 7 |

51 | Green | 6 |

52 | Green | 12 |

53 | Green | 3 |

54 | Green | 6 |

55 | Green | 4 |

56 | Green | 15 |

57 | Green | 4 |

58 | Green | 4 |

59 | Green | 6 |

60 | Green | 5 |

61 | Green | 10 |

62 | Green | 10 |

63 | Green | 18 |

64 | Green | 17 |

65 | Green | 5 |

66 | Green | 7 |

67 | Green | 3 |

68 | Green | 1 |

69 | Green | 7 |

70 | Green | 7 |

71 | Green | 5 |

72 | Green | 7 |

73 | Yellow | 11 |

74 | Yellow | 10 |

75 | Yellow | 2 |

76 | Yellow | 6 |

77 | Yellow | 25 |

78 | Yellow | 1 |

79 | Yellow | 7 |

80 | Yellow | 1 |

81 | Yellow | 15 |

82 | Yellow | 13 |

83 | Yellow | 4 |

84 | Yellow | 11 |

85 | Yellow | 1 |

86 | Yellow | 2 |

87 | Yellow | 2 |

88 | Yellow | 6 |

89 | Yellow | 1 |

90 | Yellow | 7 |

91 | Yellow | 5 |

92 | Yellow | 4 |

93 | Yellow | 16 |

94 | Yellow | 19 |

95 | Yellow | 9 |

96 | Yellow | 6 |

97 | Yellow | 4 |

98 | Yellow | 3 |

99 | Yellow | 8 |

100 | Yellow | 7 |

101 | Yellow | 18 |

102 | Yellow | 1 |

103 | Yellow | 3 |

104 | Yellow | 4 |

105 | Yellow | 1 |

106 | Yellow | 4 |

107 | Yellow | 2 |

108 | Yellow | 10 |

109 | Orange | 5 |

110 | Orange | 15 |

111 | Orange | 19 |

112 | Orange | 9 |

113 | Orange | 2 |

114 | Orange | 1 |

115 | Orange | 18 |

116 | Orange | 11 |

117 | Orange | 6 |

118 | Orange | 1 |

119 | Orange | 6 |

120 | Orange | 7 |

121 | Orange | 4 |

122 | Orange | 2 |

123 | Orange | 1 |

124 | Orange | 12 |

## Needs help with similar assignment?

We are available 24x7 to deliver the best services and assignment ready within 3-4 hours? Order a custom-written, plagiarism-free paper

Get Answer Over WhatsApp Order Paper Now