project has to be done before the 18th please help i will provide the apple stocks as well

apple stocks prices

Due: Sunday, March 28th by 11:59 PM. Late projects will not be accepted. This project is two different parts with unrelated topics. Both parts combined are worth 50 points. Please make sure to show your work in order to receive full credit. Part One of the project must be submitted in a PDF format. Part Two must be submitted as an Excel document so I may check functions/ formulas used to calculate answers. Part 1 A Poll is the process of taking a sample or collection of opinions on a subject from a selected random group for the purpose of analyzing and drawing conclusions about a larger population. We often see this with elections or medical research. For this project, you are being tasked to conduct a poll of your family and friends' opinions regarding whether or not the Covid-19 vaccine should be taken at this stage of discovery. 1. (5 points) Report the sample size. (Sample size refer to the number of participants included in a study.) 2. (5 points) Report the results as percentages of the amount of people who either agreed, disagreed, or were unsure about getting the Covid-19 vaccination. 3. (5 points) Find the margin of error. 4. (5 points) Determine the 95% confidence interval for the percentage of people who were unsure of taking the vaccine. 5. (5 points) Write a sentence using the 95% confidence interval. 4. (5 points) Determine the 95% confidence interval for the percentage of people who were unsure of taking the vaccine. 5. (5 points) Write a sentence using the 95% confidence interval. Part 11 Check the Excel document I provided for Apple Stock prices from 03/11/2020- 03/11/2021. Answer the following questions in the same Excel document: 1. (15 points) Find the mean, median, mode, the five-number summary, and the standard deviation. (Use Excel functions to answer these questions). 2. (5 points) Make a histogram on Excel. Does the stock price appear to be normally distributed, and why? (Type your answer in a cell box in Excel). Date Close 3/11/20 69 3/12/20 62 3/13/20 69 3/16/20 61 3/17/20 63 3/18/20 62 3/19/20 61 3/20/20 57 3/23/20 56 3/24/20 62 3/25/20 61 3/26/20 65 3/27/20 62 3/30/20 64 3/31/20 64 4/1/20 60 4/2/20 61 4/3/20 60 4/6/20 66 4/7/20 65 4/8/20 67 4/9/20 67 4/13/20 68 4/14/20 72 4/15/20 71 4/16/20 72 4/17/20 71 4/20/20 69 4/21/20 67 4/22/20 69 4/23/20 69 4/24/20 71 4/27/20 71 4/28/20 70 4/29/20 72 4/30/20 73 5/1/20 72 5/4/20 73 5/5/20 74 5/6/20 75 5/7/20 76 5/8/20 78 5/11/20 79 5/12/20 78 5/13/20 77 5/14/20 77 5/15/20 77 5/18/20 79 5/19/20 78 5/20/20 80 5/21/20 79 5/22/20 80 5/26/20 79 5/27/20 80 5/28/20 80 5/29/20 79 6/1/20 80 6/2/20 81 6/3/20 81 6/4/20 81 6/5/20 83 6/8/20 83 6/9/20 86 6/10/20 88 6/11/20 84 6/12/20 85 6/15/20 86 6/16/20 88 6/17/20 88 6/18/20 88 6/19/20 87 6/22/20 90 6/23/20 92 6/24/20 90 6/25/20 91 6/26/20 88 6/29/20 90 6/30/20 91 7/1/20 91 7/2/20 91 7/6/20 93 7/7/20 93 7/8/20 95 7/9/20 96 7/10/20 96 7/13/20 95 7/14/20 97 7/15/20 98 7/16/20 97 7/17/20 96 7/20/20 98 7/21/20 97 7/22/20 97 7/23/20 93 7/24/20 93 7/27/20 95 7/28/20 93 7/29/20 95 7/30/20 96 7/31/20 106 8/3/20 109 8/4/20 110 8/5/20 110 8/6/20 114 8/7/20 111 8/10/20 113 8/11/20 109 8/12/20 113 8/13/20 115 8/14/20 115 8/17/20 115 8/18/20 116 8/19/20 116 8/20/20 118 8/21/20 124 8/24/20 126 8/25/20 125 8/26/20 127 8/27/20 125 8/28/20 125 8/31/20 129 9/1/20 134 9/2/20 131 9/3/20 121 9/4/20 121 9/8/20 113 9/9/20 117 9/10/2011 Due: Sunday, March 28th by 11:59 PM. Late projects will not be accepted. This project is two different parts with unrelated topics. Both parts combined are worth 50 points. Please make sure to show your work in order to receive full credit. Part One of the project must be submitted in a PDF format. Part Two must be submitted as an Excel document so I may check functions/ formulas used to calculate answers. Part 1 A Poll is the process of taking a sample or collection of opinions on a subject from a selected random group for the purpose of analyzing and drawing conclusions about a larger population. We often see this with elections or medical research. For this project, you are being tasked to conduct a poll of your family and friends' opinions regarding whether or not the Covid-19 vaccine should be taken at this stage of discovery. 1. (5 points) Report the sample size. (Sample size refer to the number of participants included in a study.) 2. (5 points) Report the results as percentages of the amount of people who either agreed, disagreed, or were unsure about getting the Covid-19 vaccination. 3. (5 points) Find the margin of error. 4. (5 points) Determine the 95% confidence interval for the percentage of people who were unsure of taking the vaccine. 5. (5 points) Write a sentence using the 95% confidence interval. 4. (5 points) Determine the 95% confidence interval for the percentage of people who were unsure of taking the vaccine. 5. (5 points) Write a sentence using the 95% confidence interval. Part 11 Check the Excel document I provided for Apple Stock prices from 03/11/2020- 03/11/2021. Answer the following questions in the same Excel document: 1. (15 points) Find the mean, median, mode, the five-number summary, and the standard deviation. (Use Excel functions to answer these questions). 2. (5 points) Make a histogram on Excel. Does the stock price appear to be normally distributed, and why? (Type your answer in a cell box in Excel). Date Close 3/11/20 69 3/12/20 62 3/13/20 69 3/16/20 61 3/17/20 63 3/18/20 62 3/19/20 61 3/20/20 57 3/23/20 56 3/24/20 62 3/25/20 61 3/26/20 65 3/27/20 62 3/30/20 64 3/31/20 64 4/1/20 60 4/2/20 61 4/3/20 60 4/6/20 66 4/7/20 65 4/8/20 67 4/9/20 67 4/13/20 68 4/14/20 72 4/15/20 71 4/16/20 72 4/17/20 71 4/20/20 69 4/21/20 67 4/22/20 69 4/23/20 69 4/24/20 71 4/27/20 71 4/28/20 70 4/29/20 72 4/30/20 73 5/1/20 72 5/4/20 73 5/5/20 74 5/6/20 75 5/7/20 76 5/8/20 78 5/11/20 79 5/12/20 78 5/13/20 77 5/14/20 77 5/15/20 77 5/18/20 79 5/19/20 78 5/20/20 80 5/21/20 79 5/22/20 80 5/26/20 79 5/27/20 80 5/28/20 80 5/29/20 79 6/1/20 80 6/2/20 81 6/3/20 81 6/4/20 81 6/5/20 83 6/8/20 83 6/9/20 86 6/10/20 88 6/11/20 84 6/12/20 85 6/15/20 86 6/16/20 88 6/17/20 88 6/18/20 88 6/19/20 87 6/22/20 90 6/23/20 92 6/24/20 90 6/25/20 91 6/26/20 88 6/29/20 90 6/30/20 91 7/1/20 91 7/2/20 91 7/6/20 93 7/7/20 93 7/8/20 95 7/9/20 96 7/10/20 96 7/13/20 95 7/14/20 97 7/15/20 98 7/16/20 97 7/17/20 96 7/20/20 98 7/21/20 97 7/22/20 97 7/23/20 93 7/24/20 93 7/27/20 95 7/28/20 93 7/29/20 95 7/30/20 96 7/31/20 106 8/3/20 109 8/4/20 110 8/5/20 110 8/6/20 114 8/7/20 111 8/10/20 113 8/11/20 109 8/12/20 113 8/13/20 115 8/14/20 115 8/17/20 115 8/18/20 116 8/19/20 116 8/20/20 118 8/21/20 124 8/24/20 126 8/25/20 125 8/26/20 127 8/27/20 125 8/28/20 125 8/31/20 129 9/1/20 134 9/2/20 131 9/3/20 121 9/4/20 121 9/8/20 113 9/9/20 117 9/10/2011