Threadfor This Assignment You Will Use The Project 2 Excel Spreadshe For this assignment, you will use the Project 2 Excel Spreadsheet to answer the questions below. In each question, create the specified graphs using the spreadsheet and then answer the question. All answers should be posted in a thread in Discussion Board Forum 1/Project 2. You must use your own work for Questions 1–5, and any second posts require instructor permission.
Paper For Above instruction Question A: You will create a set of 5 points that are very close together and calculate the standard deviation. Then, add a sixth point that is far from the original five, and recalculate the standard deviation. The impact of adding the distant point is that the standard deviation increases. Specifically, when the points are close, the standard deviation reflects minimal variability around the mean because the data points are similar with little dispersion. Once a distant point is introduced, the variability among the data points increases significantly, which in turn raises the standard deviation because the points are more spread out from the mean. Question B: You will create two data sets, each with 8 points and a mean close to 10. The first data set should have a standard deviation around 1, and the second around 4. To achieve the larger standard deviation, you introduce more variability among the data points, spreading them further from the mean. In contrast, the dataset with a smaller standard deviation has data points clustered more tightly around the mean. Next, you will clear previous data from Question 1 and input the data set: 50, 50, 50, 50, 50. The standard deviation in this case is zero because all data points are identical, meaning there is no dispersion or variability among them. Standard deviation measures the average distance of each data point from the mean; if all points are the same, this distance is zero for each point, resulting in a standard deviation of zero. Then, you will analyze three new data sets: Data set 1: 0, 0, 0, 100, 100, 100 Data set 2: 0, 20, 40, 60, 80, 100