***PLEASE PROVIDE A STEP-BY-STEP OF EXCEL FORMULAS FOR EACH PROBLEM - ATTACHED IS A GOOGLE SHEETS FOR REFERENCE, SCREENSHOTS WITH FORMULAS PLEASE*** ****THANK YOU!!!****

https://docs.google.com/spreadsheets/d/1Zaw8NijWXggl0IQ_sHXoCZCfMd5EuAuFd87aXKupWzg/edit?usp=sharing

1. You want to rent an unfurnished one-bedroom apartment in Durham, NC, next year. The mean monthly rent for a random sample of 50 apartments advertised on Craig's List (a website that lists apartments for rent) is $1000. Assume a population standard deviation of $200. Construct a 95% confidence interval.

2.Unoccupied seats on flights cause airlines to lose revenue. Suppose a large airline wants to estimate its mean number of unoccupied seats per flight over the past year. To accomplish this, the records of 225 flights are randomly selected and the number of unoccupied seats is noted for each of the sampled flights. The sample mean is 11.6 seats and the sample standard deviation is 4.2 seats. Construct a 95% confidence interval.

3. A professor wants to know if her introductory statistics class has a good grasp of basic math. Eight students are chosen at random from the class and given a math proficiency test. The professor wants the class to be able to score above 70 on the test. The sample mean score of the six students is 79 with a sample standard deviation of 12.931. Can the professor have 95% confidence that the mean score for the class on the test would be above 70? Formulate the hypothesis, compute the test statistic, find the critical value, and draw a conclusion.

4. Suppose a consumer group suspects that the proportion of households that have three cell phones is 30%. A cell phone company has reason to believe that the proportion is not 30%. Before they start a big advertising campaign, they conduct a hypothesis test. Their marketing people survey 150 households with the result that 46 of the households have three cell phones. For the hypothesis test, use a 5% level of significance. Formulate the hypothesis, compute the test statistic, find the critical value, and draw a conclusion.

5. The administration at a college wishes to estimate, the proportion of all its entering freshmen who graduate within four years, with 95% confidence. Estimate the minimum size sample required. Assume that the population standard deviation is = 0.25 and precision level is 0.03.

6. Using the student grades data below, construct a scatter chart for midterm versus final exam grades and add a linear trendline. What is the regression model? If a student scores 75 on the midterm, what would you predict their grade on the final exam to be?

7. Forecast the IBM stock prices shown below using a two-period moving average. Compute MAD, MSE, and MAPE.

8. Forecast the DJ Industrials Index data shown below using simple exponential smoothing with a smoothing constant of 0.4.