Given below are seven observations collected in a regression…

Given below are seven observations collected in a regression study on two variables, x (independent variable) and y (dependent variable). Use Excel to:a.Compute a 95% confidence interval for E(y) when x = 5.b.Compute a 95% prediction interval for y when x = 5.     xy  212  39  68  77  86  75  92 ​

In order to estimate the difference between the yearly incom…

In order to estimate the difference between the yearly incomes of marketing managers in the East and West of the United States, the following information was gathered: EastWest n1 = 40n2 = 45  = 72 (in $1000s) = 78 (in $1000s) s1 = 6 (in $1000s)s2 = 8 (in $1000s)​a.Develop an interval estimate for the difference between the average yearly incomes of the marketing managers in the East and West. Use α = 0.05. b.At 95% confidence, use the p-value approach and test to determine if the average yearly income of marketing managers in the East is significantly different from the West. ​

A marketing firm is developing a new television advertisemen…

A marketing firm is developing a new television advertisement for a large discount retail chain. A sample of 30 people is shown two potential ads and asked their preference. The results for ad #1 follow. Use Excel to develop a 95% confidence interval estimate of the proportion of people in the population who will prefer ad #1. Prefer Advertisement #1 yesnonoyesyesno nononoyesnoyes nonoyesyesyesno yesyesnononoyes yesnoyesyesnono

Shown below is a portion of a computer output for a regressi…

Shown below is a portion of a computer output for a regression analysis relating Y (dependent variable) and X (independent variable).ANOVA   dfSSRegression  1115.064Residual13  82.936Total      CoefficientsStandard ErrorIntercept15.5321.457x –1.1060.261​a.Perform a t test using the p-value approach and determine whether x and y are related. Let α = 0.05.b.Using the p-value approach, perform an F test and determine whether x and y are related.c.Compute the coefficient of determination and fully interpret its meaning. ​

Given below are seven observations collected in a regression…

Given below are seven observations collected in a regression study on two variables, x (independent variable) and y (dependent variable). Use Excel’s Regression tool to answer the following questions: xy  212  39  68  77  86  75  92 ​a.What is the estimated regression equation?b.Perform a t test and determine whether x and y are related. Use α = 0.05.c.Perform an F test and determine whether x and y are related. Use α = 0.05.d.Find and interpret the coefficient of determination.​​​