The research firm LL Research collected data from 200 client businesses. They want to determine how the businesses compare among four variables:2015 Profit in millions of dollars2016 Profit in millions of dollars2015-2016 Two-Year Change in Daily Average Customer Visits Two-Year Average Number of EmployeesData collected for the sample of 200 businesses is contained in the file named Businesses, linked at the bottom of the page. Use all 200 data points.Managerial ReportPrepare a report (see Module folder) using the numerical methods of descriptive statistics presented in this module to learn how each of the variables contributes to the success of a client business. Be sure to include the following three items in your report. Find descriptive sample statistics (mean, median, two quartiles Q1 and Q3, minimum, maximum, range, sample standard deviation, and coefficient of variation) for each of the four variables along with an explanation of what the descriptive statistics tell us about the client businesses. Compute the percent change in profit from 2015 to 2016 for each business. Then use the z-score to determine which businesses were outliers with respect to percent change in profit. Compute the sample correlation coefficient, showing the relationship between percent change in profit and each of the other two variables (2015-2016 Two-Year Change in Daily Average Customer Visits and Two-Year Average Number of Employees). Explain what the correlation coefficients tell us about the three pairs of relationships. Use tables, charts, or graphs to support your conclusions. Requirements: Paper must be written in third person. Your paper should be four to five pages in length (counting the title page and references page) and cite and integrate at least one credible outside source. Include a title page, introduction, body, conclusion, and a reference page. The introduction should describe or summarize the topic or problem. It might discuss the importance of the topic or how it affects you or society as a whole, or it might discuss or describe the unique terminology associated with the topic. The body of your paper should answer the questions posed in the problem. Explain how you approached and answered the question or solved the problem, and, for each question, show all steps involved. Be sure this is in paragraph format, not numbered answers like a homework assignment. The conclusion should summarize your thoughts about what you have determined from the data and your analysis, often with a broader personal or societal perspective in mind. Nothing new should be introduced in the conclusion that was not previously discussed in the body paragraphs. Include any tables of data or calculations, calculated values, and/or graphs associated with this problem in the body of your assignment.

Project Week 5For these project assignments throughout the course you will need to reference the data in the ROI Excel spreadsheet. Download it here. Using the ROI data set:For each of the 2 majors consider the ‘School Type’ column.  Assuming the requirements are met, construct a 90% confidence interval for the proportion of the schools that are ‘Private’.  Be sure to interpret your results.For each of the 2 majors construct a 95% confidence interval for the mean of the column ‘Annual % ROI’.  Be sure to interpret your results.Attachment Spreadsheet:ROI Exel