Memo 4 Assignment Two Sample Significance Testing Instructions Excel Data file name: \"Two Sample Test HW4 Memo Data\" Instructions: Follow the HW memo format as noted in the sample assignment. Use a question number heading for each response. Respond with no more than two pages, readable font 12 points, and submit in Word only. Question 1 Situation: A fast food trade association wishes to compare manager salaries between its two largest members, which are McDanno's and Burger Queen. The companies provided anonymous and random manager salaries for 31 managers. The association wishes to discover if typical manager salaries vary between these two fast food giants. The salaries are reported in dollars. First, run descriptive statistics. Next, run the F-test for difference in two variance test in order to determine equality of variance and which two sample test to use. Third, run the appropriate ttest for a difference between the two means (unsummarized data). Alpha is .05. Are the data normally distributed? Is there equality of variance? Is there a difference in salary between the two restaurant chains? Report and interpret (explain) the results from both tests including the skewness and kurtosis statistics, means, p-values only, standard deviations, and size of each sample (40% of assignment points). Question 2 Situation: A manufacturer of specialized computer chips wishes to determine whether its new training program reduces the number of defective chips per 8 hour shift. Records from a random sample of 118 operators working different shifts were collected for analysis. Run descriptive statistics. Next, run a two sample test- paired t-test (unsummarized). Alpha is .05. Are the data normally distributed? Did the training make a difference (run a two-tail test)? Report and interpret (explain) the results including the skewness and kurtosis statistics, the means, pvalue only, and the sample size (30% of assignment points). Question 3 Situation: One hundred and eighty-two company employees were asked if they were interested in a pension plan. The company wishes to discover if there is a difference in interest by age group. \"Interest\" in the pension plan was recorded as \"yes\" or \"no\" and the age group was recorded as \"18-34\" and \"35 and older.\" Seventy-one 18-34 year olds were not interested and 20 were interested. Of the 35+ years old group, 8 were not interested and 83 were interested. Run a two samples test (summarized data) using the chi-square for difference between two proportions test. Alpha is .05. Is there a difference in pension interest by age group? Report and interpret your results including frequencies, percentages (proportions), p-value, and whether there is the required 5 count per cell (30% of assignment points). McDanno Burger Queen Pretraining Postraining $51,888.43 $48,889.79 12 10 $50,465.40 $56,110.39 16 9 $24,199.14 $47,518.06 8 3 $50,159.57 $52,172.97 15 10 $55,924.90 $36,003.67 16 9 $46,523.88 $53,743.43 15 5 $51,691.87 $64,425.66 24 7 $37,478.68 $56,383.56 15 3 $50,056.38 $51,381.02 9 5 $61,830.73 $49,667.86 21 12 $43,733.49 $36,611.92 17 6 $51,045.40 $21,595.10 25 9 $51,716.69 $55,670.77 17 10 $53,167.67 $43,653.02 16 9 $45,996.96 $39,805.23 20 6 $36,414.26 $33,993.24 17 14 $41,034.73 $46,118.30 10 5 $49,311.97 $57,990.59 13 9 $57,407.75 $46,607.47 11 5 $37,439.56 $58,281.68 24 5 $56,666.91 $36,964.45 17 8 $54,221.01 $50,004.94 17 8 $44,834.71 $54,280.84 18 9 $60,889.84 $37,520.17 21 10 $60,778.44 $62,362.28 17 11 $66,627.57 $56,407.35 11 0 $43,324.85 $60,336.20 21 10 $69,487.35 $33,057.07 19 6 $53,672.30 $39,486.99 15 8 $40,739.05 $50,609.84 14 8 $49,158.92 $48,140.41 22 14 11 5 19 7 16 10 22 10 26 12 19 10 10 6 15 8 7 3 15 7 13 5 15 6 8 4 21 9 19 9 17 10 10 6 12 6 18 26 11 18 22 14 20 21 16 14 15 15 11 19 18 4 18 21 16 19 11 18 25 15 19 19 20 16 11 13 18 22 11 22 20 15 24 24 27 14 29 20 13 18 10 23 28 11 22 17 9 13 5 6 9 7 10 10 7 7 8 8 8 9 8 2 9 9 8 9 6 9 11 7 8 8 7 6 4 6 8 10 5 10 10 8 12 12 14 7 14 10 7 9 8 10 14 7 11 10 20 10 12 18 17 19 21 17 15 15 15 24 25 14 28 22 22 18 14 8 5 6 9 8 7 13 10 7 7 9 13 13 7 14 11 12 9 8