**ATTACHED IS THE DATA SET AND SCENARIO TO ANSWER THE QUESTIONS FOR THIS ANALYSIS**This week you will begin working on Phase 2 of your course project. Using the same data set and variables for your selected topic, add the following information to your analysis:Discuss the importance of constructing confidence intervals for the population mean.What are confidence intervals?What is a point estimate?What is the best point estimate for the population mean? Explain.Why do we need confidence intervals?Based on your selected topic, evaluate the following:Find the best point estimate of the population mean.Construct a 95% confidence interval for the population mean. Assume that your data is normally distributed and is unknown.Please show your work for the construction of this confidence interval and be sure to use the Equation Editor to format your equations. Write a statement that correctly interprets the confidence interval in context of your selected topic. Based on your selected topic, evaluate the following:Find the best point estimate of the population mean.Construct a 99% confidence interval for the population mean. Assume that your data is normally distributed and is unknown.Please show your work for the construction of this confidence interval and be sure to use the Equation Editor to format your equations. Write a statement that correctly interprets the confidence interval in context of your selected topic. Compare and contrast your findings for the 95% and 99% confidence interval.Did you notice any changes in your interval estimate? Explain.What conclusion(s) can be drawn about your interval estimates when the confidence level is increased? Explain. This assignment should be formatted using APA guidelines and a minimum of 2 pages in length.

Normal DistributionOne theory about the daily changes in the closing price of a stock is that these changes follow arandom walk – that is, these daily events are independent of each other and move upward or downward in a random manner – and can be approximated by a normal distribution. To test this theory, collect the opening and closing prices of stocks from for your favorite company or brand.Initial Post:Choose your favorite company or brand and search finance.yahoo.com with that company name and “historical stock prices.” Download the stock history for this company for the past 6 weeks by selecting the appropriate dates and clicking on “Download to Spreadsheet” at the bottom of page.Calculate the daily change in the closing stock prices by taking the difference between the closing and opening price for the day. This is the daily stock change.Calculate the mean and standard deviation of the daily stock changes by running the Descriptive Statistics in Excel Data Analysis. Share the summary table.Consider the mean, median and mode (if it exists). Is your daily stock change distribution right skewed (median < mean), left skewed (mean < median), or symmetric (mean ≈ median)? What other considerations would you look at to determine whether or not this distribution is approximately normally distributed?See Example post.First response: Read a classmate’s response. Consider investing in your classmate’s stock and assume that the daily change is normally distributed. Using Normal.xlsx, your classmate’s mean and standard deviation, determine the probability for the daily change of this stock to have:A decrease of 0.5 point or more (X ≤ -0.5)?An increase of more than 0.5 point (X > 0.5)?A decrease of more 1 point or more (X ≤ -1)?An increase of more than 1 point (X > 1)?See Example post.Second Response: Read a different classmate’s response. Consider investing in your classmate’s stock and assume that it is normally distributed. If you wanted to be 95% sure of what the daily change would be, what range for a daily change would you expect? Use Normal.xlsx.See Example post.