Final Exam–MGMT 650-Central tendency is most commonly referred

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. Thepoint 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 deletethis 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 completedindependently. Show your work to gain partial credit.Be sure your name is on your document. Good luck! Name:Problem # Point Value123456789101112131415161718192021222324252627282930 Sum 331111111111141161131121119152015100 Your Points 0 The 13 questions on this page are multiple choice. Please enter your answers into column M in the shaded box.Q1. Central tendency is most commonly referred to as the numberical center of the data set:Which of these are common representations of central tendencyA. MeanB. VarianceC. ModeD. MedianE. RangeF. Standard Deviation Your Answer to Q1: Total Points = Your Answer to Q2 #1Your Answer to Q2 #2Your Answer to Q2 #3 Total Points = 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 = Q2: Match the appropriate inferential statistical test to the provided definitions.A. t testB. ANOVAC. Chi-Square 1. Used to test independence for more than 2 means (i.e….pares the means of more than 2 groups)Letter: _______2. Used to test the independence between 2 or more categoricalvariablesLetter: _______3. Used to compare means of 2 groupsLetter: _______ Q3: What is the risk of performing the t=test using pooled variance, if the variances between the 2samples are actually unequal (i.e.. fail the F test) ?A. Your result will only be applicable for a one-tail t-testB. You will fail to adjust for sample size.C. You may falsely accept or reject the null hypothesis. Q4. Let’s assume we know that 1% of women over the age of 40 have breast cancer. Let’s assume that90% of women who have breast cancer will test positive for breast cancer in a mammogram. Eightpercent of women that do NOT have breast cancer will also test positive. What is the probability ofhaving cancer if you have a positive test (Select the correct answer from the choices below.)A. 0.90B. 0.01C. 0.10D. 0.08 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.” 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 deviationsfrom the arithmetic mean. (Select the correct answer from the choices below.)A. 99.7B. 95.0C. 75.0D. 68.3 Q7. A new drug is created to help people with depression. When testing the drug, what are the nulland 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. H A: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 are144 sq. feet, 160 sq. feet, 190 sq. feet, 180 sq. feet, and 210 sq. feet. What type of data is this?A. Quantitative continuous dataB. Quantitative discrete dataC. Qualitative dataD. Binomial Distribution dataQ9. During an election year, we see articles in the newspaper that state confidence intervals in terms ofproportions or percentages. For example, a poll for a particular candidate running for president mightshow that the candidate has 40% of the vote within 3 percentage points. This election polls wascalculated 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 ifthere is a linear change in the _______ variable based on a change in the ______ variable. The dependentvariable will always be a ________ variable. If a negative relationship is found, this means that as theindependent variable _______, the dependent variable _______.(Select the correct answer from the choices below to correctly fill in the blank words.)A. dependent, independent, categorical, increases, decreasesB. independent, dependent, categorical, increases, decreasesC. dependent, independent, numerical, increases, decreasesD. dependent, independent, numerical, increases, increasesE. 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 / meanB. Variance * meanC. Standard deviation / meanD. 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 oneswhere adding the results of the two throws together equals seven? For example, if you get 1 on the firsttoss 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) Total 0 The 13 questions on this page are multiple choice. Please enter your answers into cQ14: Choose all answers that describe an array function in Excel.A. Uses curly bracesB. Uses parenthesesC. Elements in a vertical array are separated by commasD. Elements in a vertical array are separated by semicolonsE. You must use other computer keys besides return to create the functionF. 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 isA. .028B. .17C. .33 Q16: Suppose that a 90% confidence interval states that the population mean is greater than 100 and less than 200. Hinterpret 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 distributionB. Chi Square distributionC. Monica’s Z distributionD. F distributionE. G distributionQ18: 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 gFemale, 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)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 athe analysis will involve comparing two dependent means. Q19: What is the null hypothesis that ANOVA tests?A. H(0): All the population means are equalB. H(0): There is a difference between the means of the populations Q19: What is the null hypothesis that ANOVA tests?A. H(0): All the population means are equalB. 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.?GraduatedExperimentalControlTotal 116 Did notGraduate 51Graduated A.ExperimentalControlTotal 7343116Graduated B.ExperimentalControlTotal 5957116 Total8582167Did notGraduate Total 123951Did notGraduate262551 8582167Total8582167 Q21: Which of the following are functions with x denoting the independent variable and y denoting the dependent variaapply.A. y = f(x)B. x = f(y)C. y = a + bxQ22: A car dealer measures the number of cars sold by each salesperson in January. This data is:A. Time seriesB. Cross sectionalC. NumericalD. 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. 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 ErrorB. Multiple-Square ErrorC. Mean-statistical ErrorD. Multiple-statistical Error Q26: A UMUC professor wants to determine if her students are getting taller. She obtains the height of 50 of her studeyears. What is the df?A. 51B. 50C. 49D. 100E. 98 enter your answers into column M in the shaded box.Your Answer to Q14: Total Points = e is Your Answer to Q15: Total Points = ter than 100 and less than 200. How would you Your Answer to Q16: Total Points = Your Answer to Q16: Total Points = Your Answer to Q18: Total Points = Your Answer to Q19: Total Points = er. ply. e?”) and taken from two distinct group (e.g. ps (e.g. Graduate, Undergraduate) the analysis will ject (e.g. subject’s weight before and after dieting) mogeneity or independence.? Your Answer to Q20: Total Points = nd y denoting the dependent variable? Choose all that Your Answer to Q21: Total Points = his data is: Your Answer to Q22: Total Points = Your Answer to Q23: Total Points = Your Answer to Q24: Total Points = mal distribution.egrees of freedom parameter. omes more skewed. rface water.nd watching TV. rface water.nd watching TV. tains the height of 50 of her students over the Your Answer to Q25: Total Points = Your Answer to Q26: Total Points = Total tal Points = tal Points = tal Points = tal Points = 0 Person 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200 Waiting Time 3525405152551636492731 A)2120283015323439343534133736335570 B)47623155224347573733454746143023343838356021 C)291252253146434744242745412936394441295743394647322949262245446052513938433827204642444028263530303433334643325120443738313346494345544144573548394937304932434335342458323936665147514043362651352546464242324543491043532138525540395738314738484253372823123941384041533927244048233243363536343044395141 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 probabilityof A. Show your Bins here:Wait times in Mins. Number of customers Total Show your graph of the frequency distribution here. P (A) 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 thatthe true mean is 50 against the alternative that the true mean is not50. Show your work.b) State the conclusion. a) B) 5152 5360 4930 4345 4746 Q29. Refer to the tab titled “Service Satisfaction” for data required to solve this problem. You are looking at results of aservice department from 2 different Car Dealerships. Forty customers from each dealership took a survey related to thecleaned and serviced. The survey results were calculated on a scale from 0 to 10, with 10 indicating complete satisfactioDealership B. You want to know if customer satisfaction in the service department was the same or different based on thAnswer 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 satistactionB. ______ Dealership B customer satisfaction #3. Perform the appropriate statistical test to test for significance between the the two groups. Note, use “data analyresults:A. What p-value did you find and is this significant?B. Would you accept or reject the null hypothesis? ou are looking at results of a survey of customer satisfaction with theirtook a survey related to their satisfaction after getting their brakesdicating complete satisfaction. The Dealerships are titled Dealership A andsame or different based on the dealership. low.) rship A or Dealership B. oups. Note, use “data analysis” to get your result. Based on your Q30. Refer to the tab titled “Yarn Purchased” for data required to solve this problem. This data represents thenumber 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 thedata 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. ata represents the he 4 colors. Use thee test appropriately. ? Explain why. Dealership A Dealership B9.19.97.86.18.16.88.88.36.77.55.610.010.09.99.18.38.96.17.69.39.98.46.57.28.55.37.76.98.39.05.06.97.85.55.97.98.38.66.69.58.29.39.35.28.88.29.27.08.010.09.78.07.67.08.95.98.810.08.28.88.86.37.97.36.47.59.29.07.28.28.37.47.58.38.27.68.39.78.18.2 Customer1234567891011121314151617181920212223242526272829303132333435363738394041424344454647 Color of yarnBlueBlueBlueBlueBlueBlueBlueBlueBlueBlueBlueBlueBlueBlueBlueBlueBlueBlueGreenGreenGreenGreenGreenGreenGreenGreenGreenGreenGreenGreenGreenGreenGreenGreenGreenGreenGreenGreenGreenGreenGreenGreenGreenGreenGreenGreenGreen Number ofSkeinspurchased24114664315244813129106761214678197717215325541321420363764 4849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697 GreenGreenGreenGreenGreenGreenGreenGreenGreenGreenGreenGreenGreenGreenGreenGreenGreenGreenGreenGreenGreenGreenGreenGreenGreenYellowYellowYellowYellowYellowYellowYellowYellowYellowYellowYellowYellowYellowYellowYellowYellowYellowYellowYellowYellowYellowYellowYellowYellowYellow 41376123641544651010181757317757111026251711513411122617541619964 9899100101102103104105106107108109110111112113114115116117118119120121122123124 YellowYellowYellowYellowYellowYellowYellowYellowYellowYellowYellowOrangeOrangeOrangeOrangeOrangeOrangeOrangeOrangeOrangeOrangeOrangeOrangeOrangeOrangeOrangeOrange 3871813414210515199211811616742112