Using Excel For Data Analysis This Assignment Is About Using Your Statistical Knowledge and Applying It To Real World Issues Read The Article Called, "U.S. Parties Steady During Trump Era"

https://news.gallup.com/poll/274694/party-preferences-steady-during-trump-era.aspx

Home Work Excel Assignment: Using The Time Series Graph Called, "U.S. Party Identification (Including Independent Leanings)" Answer The Following Questions:

1) Always consider the source of data. What is the source of this data and is it considered a good source? How long has the source been in existence? Is a poll a sample? If so, please explain? If it is a sample, should there be error; explain? How many people were polled in 2019 and is that enough data points? Is an election such as the US Presidential election a sample? If so, would you expect sample error? How does the Central Limit Theorem apply to this poll? 2) When was the article written? Name events which might have impacted the polling since the article was written? What polling changes would you predict has occurred since the article was written ... meaning has one party benefited more than the other since the article was written? 3) USE EXCEL and Provide The Output: Calculate the Mean and a 95% Confidence Interval (5% Alpha) for Democrats. 4) USE EXCEL and Provide The Output: Calculate the Mean and a 95% Confidence Interval (5% Alpha) for Republicans. 5) Based on the above data in questions 3 & 4, which political party would you have predicted to win the presidential election of fall 2020? Explain!!! Use your statistical knowledge!!!!!!