While this is older news, the election 2

While this is older news, the election 2016 was an interesting one because all of the election polls favored Hilary Clinton.  This was obviously not the case and Trump was declared the winner by some very narrow margins.

Read at least two of the articles and write about why the election polls went wrong and what (if anything) could be done to have more accurate election polls.  Do you think you think the election would have turned out the same if they knew that Trump was in the lead?  Will this information change how you view polls and statistics you hear and read about in the news?  Make sure to cite which sources you use

https://www.telegraph.co.uk/news/2016/11/09/how-wrong-were-the-polls-in-predicting-the-us-election/

https://www.chronicle.com/article/academic-pollsters-didnt-see-all-those-trump-voters-coming-either-why-not/

https://www.wpr.org/polls-missed-mark-2016-experts-say-things-are-different-2020

https://fivethirtyeight.com/features/the-polls-missed-trump-we-asked-pollsters-why/

https://www.usatoday.com/story/news/politics/elections/2016/2016/11/09/pollsters-donald-trump-hillary-clinton-2016-presidential-election/93523012/

https://www.nytimes.com/2016/11/10/technology/the-data-said-clinton-would-win-why-you-shouldnt-have-believed-it.html

https://www.huffpost.com/entry/pollsters-and-forecasters-had-a-rough-night_n_5822c343e4b0e80b02cdee13

https://www.pewresearch.org/fact-tank/2016/11/09/why-2016-election-polls-missed-their-mark/

PART 2

Also provided is a video on how to do linear regression in excel.  It is IMPERATIVE that you have Microsoft excel for this assignment and the remainder of this course as we ill be using it exclusively to solve the problems

Linear Regression in Excel

6. (13.5) Zagat publishes restaurant ratings for various locations in the United States.  The file RESTAURANT contains the Zagat ratings for food, decor, service, and the cost per person for a sample of 100 restaurants located in New York city and in a suburb of New York City.  Develop a regression Model to predict the cost per person, based  on a variable that represents the sum of the ratings for food, decor, and service

a. construct a scatter plot in excel

b. Assume a linear relationship, find bo and b1

c. Interpret the meaning of the y-intercept bo and the slope b1 in this problem

d. Predict the mean cost per person for a restaurant with a summated rating of 50

e.  What should you tell the owner of a group of restaurants in this geographical area about the relationship between summated rating and the cost of a meal