Description Homework 11 concerning ANOVA. Instructions Choose or provide the best answer. Multiple Attempts Not allowed. This test can only be taken once. Force Completion This test can be saved and resumed later. Question Completion Status:
2016/11/18 Take Test: F16 Homework 11: (ANOVA) – 2016FallTECN221… https://myasucourses.asu.edu/webapps/assessment/take/launch.jsp?course_assessment_id=_742200_1&course_id=_334341_1&content_id=_13633505_1… 1/6 Take Test: F16 Homework 11: (ANOVA) Test Information Description Homework 11 concerning ANOVA. Instructions Choose or provide the best answer. Multiple Attempts Not allowed. This test can only be taken once. Force Completion This test can be saved and resumed later. Question Completion Status: Save All Answers Close Window Save and Submit In this homework you will need to conduct ANOVA and use excel. There is a video on how to conduct ANOVA in excel on the videos tab or you can find it here. To help me be sure that you referenced the video and have an idea about how to do ANOVA in excel what is the F statistic I found in the video? Answer to 2 decimal places; you can round up or down. 9.86 QUESTION 1 0.5 points Saved The homework data set has a tab for homework 11 which is the Sales Salary data. The data show the salaries for sales professionals in the San Fransisco area along with information on whether the person is employed in inside sales or outside sales positions, this is the “Position” variable. There is also information on the years of experience of the sales professional coded as low (110 years), medium (1120 years), and high (21 or more years). Open the data. If you have opened the data select true. True False QUESTION 2 0.5 points Saved How many observations are in the data set? QUESTION 3 0.5 points Save Answer What is the average salary in the SalesSalary data set? Answer to the nearest dollar but do not include a dollar sign in your answer. QUESTION 4 1 points Save Answer QUESTION 5 1 points Save Answer 2016/11/18 Take Test: F16 Homework 11: (ANOVA) – 2016FallTECN221… https://myasucourses.asu.edu/webapps/assessment/take/launch.jsp?course_assessment_id=_742200_1&course_id=_334341_1&content_id=_13633505_1… 2/6 What is the maximum salary in the SalesSalary data set? Answer to the nearest dollar but do not include a dollar sign in your answer. What is the average salary in the SalesSalary data set for people with low experience? Answer to the nearest dollar but do not include a dollar sign in your answer. QUESTION 6 1 points Save Answer Create a new table for the Sales Salary data with 3 columns. Each column will have the salaries in it with one column for the low experience people, one column for the medium experience people and one column for the high experience people. You might want to sort the data to make it easier to create this new table. You created a new table with low, medium and high columns where all the values are the salaries. True False QUESTION 7 1 points Save Answer Conduct ANOVA to test the hypothesis that the average salaries are the same for all levels of experience using the Sales Salary data set. Note that it will probably be more convenient to use the new table you just made. What is MSE (also known as MSW or mean squares within)? Answer to the nearest whole number. QUESTION 8 1 points Save Answer Conduct ANOVA to test the hypothesis that the average salaries are the same for all levels of experience using the SalesSalary data set. What is the value of the test statistic? Answer to two decimal places. QUESTION 9 1 points Save Answer Conduct ANOVA to test the hypothesis that the average salaries are the same for all levels of experience using the SalesSalary data set. What is the critical value when alpha=.05? Answer to two decimal places. QUESTION 10 1 points Save Answer Using the SalesSalary data test the null hypothesis that the average salaries are the same for all levels of experience. Conduct this test at the .05 level of significance. Fail to reject the null hypothesis because the test statistic is greater than the critical value. Fail to reject the null hypothesis because the test statistic is less than the critical value. Reject the null hypothesis because the test statistic is greater than the critical value. QUESTION 11 1 points Save Answer 2016/11/18 Take Test: F16 Homework 11: (ANOVA) – 2016FallTECN221… https://myasucourses.asu.edu/webapps/assessment/take/launch.jsp?course_assessment_id=_742200_1&course_id=_334341_1&content_id=_13633505_1… 3/6 Reject the null hypothesis because the test statistic is greater than the critical value. Reject the null hypothesis because the test statistic is less than the critical value. Using the SalesSalary data you reject the null hypothesis that the average salaries are equal for all experience levels at the .001 level of significance. True False QUESTION 12 1 points Save Answer Consider the ANOVA table here. What is MSTR (also known as MSB) ? Answer to two decimal places. QUESTION 13 1 points Save Answer Consider the ANOVA table here. What is the total sum of squares? Answer to two decimal places. QUESTION 14 1 points Save Answer Consider the ANOVA table here. What is the pvalue? Answer to three decimal places. QUESTION 15 1 points Save Answer 2016/11/18 Take Test: F16 Homework 11: (ANOVA) – 2016FallTECN221… https://myasucourses.asu.edu/webapps/assessment/take/launch.jsp?course_assessment_id=_742200_1&course_id=_334341_1&content_id=_13633505_1… 4/6 Consider the ANOVA table here. How many observations were there in this data set? QUESTION 16 1 points Save Answer Suppose there are 3 numerator degrees of freedom and 15 denominator degrees of freedom. What is the critical F value for a .05 level of significance test? Answer to two decimal places. QUESTION 17 1 points Save Answer Suppose there are 4 treatments and each one has 6 observations. You are using the data to conduct ANOVA. What is the critical F value for a .05 level of significance test? Answer to two decimal places. QUESTION 18 1.5 points Save Answer For the ANOVA output below certain fields are missing. What is the total sum of squares (round to the nearest whole number)? QUESTION 19 1.5 points Save Answer For the ANOVA output below certain fields are missing. How many degrees of freedom are there for the denominator in the F statistic? QUESTION 20 1.5 points Save Answer 2016/11/18 Take Test: F16 Homework 11: (ANOVA) – 2016FallTECN221… https://myasucourses.asu.edu/webapps/assessment/take/launch.jsp?course_assessment_id=_742200_1&course_id=_334341_1&content_id=_13633505_1… 5/6 For the ANOVA output below certain fields are missing. What is MSTR (also known as MSB)? Answer to one decimal point. QUESTION 21 1.5 points Save Answer For the ANOVA output below certain fields are missing. What is MSE (answer to one decimal point)? Also, recall that some people refer to MSE as MSW since different people use different terminology. QUESTION 22 1.5 points Save Answer Consider the ANOVA table in the previous question where SSTR is 284.4. Because 1.6476<3.806 you fail to reject the hypothesis the that population means of the groups are equal. True False QUESTION 23 1 points Save Answer In the work place people never use excel or other software to perform statistical analysis, instead they just answer multiple choice questions that their bosses give them. Accordingly, having some basic ideas about statistical analysis in excel is completely worthless. QUESTION 24 1 points Save Answer 2016/11/18 Take Test: F16 Homework 11: (ANOVA) – 2016FallTECN221… https://myasucourses.asu.edu/webapps/assessment/take/launch.jsp?course_assessment_id=_742200_1&course_id=_334341_1&content_id=_13633505_1… 6/6 Click Save and Submit to save and submit. Click Save All Answers to save all answers. Save All Answers Close Window Save and Submit True False