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