InstructionsScenario (information repeated for deliverable 01, 03, and 04)A major client of your company is interested in the salary distributions of jobs in the state of Minnesota that range from $30,000 to $200,000 per year. As a Business Analyst, your boss asks you to research and analyze the salary distributions. You are given a spreadsheet that contains the following information:A listing of the jobs by titleThe salary (in dollars) for each jobDeliverable 3 - Confidence Intervals.xlsxYou have previously explained some of the basic statistics to your client already, and he really liked your work. Now he wants you to analyze the confidence intervals.Background information on the DataThe data set in the spreadsheet consists of 364 records that you will be analyzing from the Bureau of Labor Statistics. The data set contains a listing of several jobs titles with yearly salaries ranging from approximately $30,000 to $200,000 for the state of Minnesota.What to SubmitYour boss wants you to submit the spreadsheet with the completed calculations, answers, and analysis.

Give an example of an interval estimate of an average or proportion you may use in your daily life. For instance, you may say that you are pretty sure your average commute time is between 25-30 minutes, or you are fairly confident that between 60-65% of the population love dogs. Collect some data to see how well your intuition is working. First, does your sample data meet all assumptions necessary to construct the confidence interval of the type you need? Even if it doesn’t, construct and interpret the confidence interval. POST this is a correct example of the question:"A confidence interval is a range of values so defined that there is a specified probability that the value of a parameter lies within it. In statistics, a confidence interval is a type of estimate computed from the statistics of the observed data. This proposes a range of plausible values for an unknown parameter. The interval has an associated confidence level that the true parameter is in the proposed range.            Between driving to work and providing morning transportation for my nanny, I estimate the average amount of miles I drive per week is about 200 miles. Calculating my Confidence Interval, adding 14.8 miles to and from work are equal to 29.6 miles per workday, 7.8 miles to and from my Nanny’s house equal to 15.6 miles per workday day and altogether the daily workday mileage, including transportation for my nanny, is 45.2 miles. In addition, misc. mileage, such as trips to the grocery store, equal an average of 10 miles per work week – as the grocery store is extremely close to home. 45.2 miles four times a week is 180.8 miles per work week. 180.8 plus 10 for misc. mileage is 190.8 The amount of mileage on two my days off has been represented numerically by “0” and the other with “10” to compensate for the misc. mileage. Ending with:Mean (?): 27.257142857143Standard deviation (?): 20.947202823347Weekly Mileage Data Set:45.2, 0, 45.2, 45.2, 45.2, 0, 10Weekly MileageWeek DaysMileage Per DayMonday45.2Tuesday0Wednesday45.2Thursday45.2Friday45.2Saturday0Sunday1095% Confidence Interval: 27.26 ± 15.5(11.8 to 42.8) "With 95% confidence the population mean is between 11.8 and 42.8, based on only 7 samples." Short Styles:27.26 (95% CI 11.8 to 42.8)27.26, 95% CI [11.8, 42.8]Margin of Error: 15.5Sample Size: 7Sample Mean: 27.26Standard Deviation: 20.95Confidence Level: 95%        In personally driving these miles on a regular basis, I have all assumptions necessary to construct the confidence interval of the type that I need."