# Bus520- Business analytics and decision making (excel data analysis)

Description

MODULE 2 (note: Module 1 is completed and attached as a reference) 3 excel templates are all attached to be completed Module 2 – SLP CONFIDENCE INTERVALS AND HYPOTHESIS TESTING Assume once again that you are a consultant who works for the Diligent Consulting Group. You are continuing to work on the analysis of the customer database from Module 1. SLP Assignment Expectations Complete the following tasks in the Module 2 SLP assignment template: 1. Generate a 95% confidence interval for the following two variables by hand: “Annual Amount Spent on Organic Food” and “Age.” 2. Generate a 95% confidence interval for the following two variables using the Excel formula =CONFIDENCE.T(): Annual Income and Number of People in the Household. 3. Interpret the confidence intervals for each of the variables. 4. The client insists the average income of his organic food customers is \$150,000. Conduct a hypothesis test at the 0.10 level to test his statement. What is your decision? MODULE 3 Module 3 – SLP SIMPLE LINEAR REGRESSION Assume once again that you are a consultant who works for the Diligent Consulting Group. You are continuing to work on the analysis of the customer database from Modules 1 and 2. SLP Assignment Expectations Complete the following tasks in the Module 3 SLP assignment template: 1. Create a scatterplot in Excel with “Annual Amount Spent on Organic Food” on the y (vertical) axis and “Age” on the x (horizontal) axis. 2. Insert a trendline. 3. What does the trendline indicate about the relationship between these two variables? 4. Calculate the correlation coefficient for these two variables using the =CORRELATION() formula in Excel. 5. Interpret the correlation coefficient. 6. Does the correlation coefficient agree with the slope of the best fit line? Explain. 7. Add the equation for the best fit line on the chart. 8. Does this equation match the linear regression equation from the Case for this module? Explain. MODULE 4 Module 4 – SLP MULTIVARIATE ESTIMATION AND MODEL FIT Assume once again that you are a consultant who works for the Diligent Consulting Group. You are continuing to work on the analysis of the customer database from Modules 1 through 3. SLP Assignment Expectations Complete the following tasks in the Module 4 SLP assignment template: 1. Compare the coefficients of determination (r-squared values) from the three linear regressions: simple linear regression from Module 3 Case, multivariate regression from Module 4 Case, and the second multivariate regression with the logged values from Module 4 Case. Which model had the “best fit”? 2. Calculate the residual for the first observation from the simple linear regression model. Recall, the Residual = Observed value – Predicted value or e = y – ŷ. 3. What happens to the overall distance between the best fit line and the coordinates in the scatterplot when the residuals shrink? 4. What happens to the coefficient of determination when the residuals shrink? 5. Consider the r-squared from the linear regression model and the r-squared from the first multivariate regression model. Why did the coefficient of determination change when more variables were added to the model?

Pages (550 words)
Approximate price: -

Why Us

At MyMasterPapers.com, you are assured of professional essay writing help from the leading experts online. Quality comes at the forefront of our custom writing service to ensure that all our customers are satisfied with the work delivered. We value repeat customers. For this reason, we ensure that each task is completed to perfection for high scores.

Top Writers

Our hiring process is highly intensive. The writers are exposed to a strict selection procedure before hiring to ensure that we acquire the most qualified, well-educated and experienced writers. Our team of writers, professors, editors and researchers will ensure that you get incredible results.

Plagiarism-Free Papers

We highly discourage plagiarism. For this reason, we have trained our writers in such a way that all the papers are written from scratch and are free from plagiarism. We also pay attention to ensure that each paper is completed as per the instructions provided. Referencing and citations are done as per the paper format selected by the customer. These include: APA, MLA, Chicago, Harvard, Turabian among others.

You can contact our support team via the chat window at the bottom right corner. Alternatively, feel free to email us via our support email: support@mymasterpapers.com. Our team is available 24/7 to respond to your queries and guide you though where need be.

Swift Delivery & 100% Money Back Guarantee

Simply choose the desired deadline when placing the order. The task is assigned to the most qualified writer as soon as the order is successfully placed. All the papers are delivered to you within the deadline selected. In case a paper cannot be delivered within the deadline selected, we request for a deadline extension within the shortest time possible.

Free Unlimited Revisions

Our customers can always request for a revision in case they feel that something needs to be added or changed after the final paper has been delivered. We do not charge for revisions. However, we highly discourage our customers from misusing this policy.

Try it now!

## Calculate the price of your order

Total price:
\$0.00

How it works?

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Our Services

Mymasterpapers.com specializes in custom essay writing for all level of students. Simply relax as we get your paper done within the timeline indicated.

Our team of skilled writers and researchers is readily available to get any type of academic paper completed. We deliver high quality papers and projects to our customers to ensure that we maintain a long-term relationship that will shine your academic career.