11/15 Please solve this problems in excel. Thank you

A medicine board would like to investigate the theon that a mother's shoe size can be used to predict an infa of 10 m of the shoe sizes Table of shoe size and birth weight X CI Shoe Size Birth Weight 7.5 7.3 a. Cons 8.0 7.9 9.0 8.2 O A. 8.5 9.5 9 - 8.5 7.8 8.0 6.8 8.5 9.0 Shoe Size 7.5 6.4 7+ 8.0 8.9 9.0 6 - 9.7 Shoe Size b. Cald The slo Print (Type it Done c. Prov The slope indicates an increase of corresponds to of in the avaranaSuppose a marketing research firm would like to examine if the social networking site that a person primarily uses is influenced by his or her age. In a randomly drawn sample, 353 social network users were asked which site they primarily visited. These data are presented in the following table along with each person's age group. Complete parts a. through c. below. Click the icon to view the data table. Calculate the chi-square test statistic. If necessary, combine age groups. x2 = (Round to two decimal places as needed.) Find the chi-square critical value, xa . Xa =(Round to two decimal places as needed.) Determine the result of the test. Choose the correct answer below. O A. Reject Ho. The test statistic does not fall into the rejection region. O B. Reject Ho. The test statistic falls into the rejection region. O C. Fail to reject Ho. The test statistic does not fall into the rejection region. O D. Fail to reject Ho. The test statistic falls into the rejection region. b. What conclusions can be made based on these results?Suppose a marketing research firm would like to examine if the social networking site that a person primarily uses is influenced by his or her age. In a randomly drawn sample, 353 social network users were asked which site they primarily visited. These data are presented in the following table along with each person's age group. Complete parts a. through c. below. Click the icon to view the data table. b. What conclusions can be made based on these results? There is evidence to indicate that c. Determine the p-value using technology and interpret its meaning. p-value = (Round to three decimal places as needed.) Interpret the meaning of the p-value. The p-value is the probability of observing a as extreme or more extreme than the one observed under the assumption that the is true. A p-value less than the significance level a means that the is enough that the should be rejected. For this test, the p-value is a = 0.01, so the There is evidence to indicate thatSuppose a marketing research firm would like to examine if the social networking site that a person primarily uses is influenced by his or her age. In a randomly drawn sample, 353 social network users were asked which site they primarily visited. These data are presented in the following table along with each person's age group. Complete parts a. through c. below. Click the icon to view the data table. a. Using a = 0.01, perform a chi-square test to determine if age group and social networking site used are independent of one another. Identify the null and alternative hypotheses for a chi-square test of independence based on the information in the table. Choose the correct answer below. O A. Ho: Age group and social networking site are not independent of one another. H1: Age group and social networking site are independent of one another. O B. Ho: Age group and social networking site are independent of one another. Hy: Age group and social networking site are not independent of one another. O C. Ho: Age group and social networking site are independent of one another. H, : The age group affects the social networking site. O D. Ho: Age group and social networking site are independent of one another. Hy: The social networking site used affects the age group. Calculate the chi-square test statistic. If necessary, combine age groups. x2 = (Round to two decimal places as needed.)A medicine board would like to investigate the theory that a mother's shoe size can be used to predict an infant's birth weight in pounds. The accompanying table records a random sample of the shoe sizes of 10 mothers and the birth weights of their infants. Complete parts a through f. Click the icon to view the table showing shoe size and birth weight. a. Construct a scatter plot for these data. Choose the correct graph below. O A. OB. O C. O D. 10- 97 10 7 Shoe Size Shoe Size Birth Weight Birth Weight 5- 5- 10 9 Un - 10 Birth Weight Shoe Size Birth Weight Shoe Size b. Calculate the slope and y-intercept for the regression formula. The slope is and the y-intercept is (Type integers or decimals rounded to three decimal places as needed.) c. Provide an interpretation for the value of the slope. The slope indicates an increase of corresponds to of in the avaranaThis test: 60 Question 15 of 15 > point(s) possible This question: 6 point(s) possible Submit test Suppose a marketing research firm would like to examine if the social networking site that a person primarily uses is influenced by his or her age. In a randomly drawn sample, 353 social network users were asked which site they primarily visited. These data are presented in the following table along with each person's age group. Complete parts a. through c. below. Click the icon to view the data - X Data table a. Using a = 0.01, perform a chi-squ are independent of one another. Social Networking Site Age Group Site A Site B Site C Identify the null and alternative hyp 2-17 30 15 information in the table. Choose the 18-34 110 20 14 O A. Ho: Age group and social n 35-54 91 19 17 55 + 27 3 6 H1: Age group and social n O B. Ho: Age group and social n H, : Age group and social n Print Done O C. Ho: Age group and social n H1: The age group affects t O D. Ho: Age group and social networking site are independent of one another. Hy: The social networking site used affects the age group. Calculate the chi-square test statistic. If necessary, combine age groups. x2 = (Round to two decimal places as needed.)A medicine board would like to investigate the theory that a mother's shoe size can be used to predict an infant's birth weight in pounds. The accompanying table records a random sample of the shoe sizes of 10 mothers and the birth weights of their infants. Complete parts a through f. Click the icon to view the table showing shoe size and birth weight. ( type IIEyeIS VI UCCIIIIaIS VUIlucu LU u lice ucciilial places as NIEcucu.) c. Provide an interpretation for the value of the slope. The slope indicates an increase of corresponds to in the average (Type an integer or decimal rounded to three decimal places as needed.) d. Predict the birth weight for a shoe size of 8.0. The predicted birth weight is |pounds. (Type an integer or decimal rounded to one decimal place as needed.) e. Calculate the SST. SST = (Type an integer or decimal rounded to two decimal places as needed.) f. Partition the SST into the SSR and the SSE. SSR = and SSE = (Type integers or decimals rounded to two decimal places as needed.)