microsoft ® excel ® statistical tools W r i t i n g

**Purpose of Assignment**

This assignment provides students with practice in understanding when or why ANOVA and linear regression are identified based on parameters. Students will learn to implement these statistical measures for better business decision-making.

**Assignment Steps**

**Resources: **Week 5 Videos; Week 5 Readings; Statistics Lab

Tutorial help on Excel^{®} and Word functions can be found on the Microsoft^{®} Office website. There are also additional tutorials via the web offering support for Office products.

**Prepare** an 11- to 15-slide Microsoft^{®} PowerPoint^{®} presentation for the senior management team based on the business problem or opportunity you described in Weeks 3-4.

**Include **on the slides what you would want the audience to see (include appropriate visual aids/layout) and include in the speaker’s notes section what you would say as you present each slide. If any source material is quoted or paraphrased in the presentation, use APA citations and references.

**Draw **on material you developed in the Week’s 3 and 4 assignments.

**Include** the following in your presentation:

- Introduction slide
- Agenda slide
- Describe the organization, with a brief description
- Explain the business problem or opportunity
- Describe the hypothesis
- Analyze why the business problem is important
- Identify what variable would be best to measure for this problem and explain why
- Identify statistical methods used to analyze data
- Apply data analysis techniques to this problem (tell which techniques should be used: descriptive statistics, inferential stats, probability) and explain why
- Apply a possible solution to the problem/opportunity, with rationale
- Evaluate how data could be used to measure the implementation of such a solution
- Conclusion
- Reference slide (if any source material is quoted or paraphrased throughout the presentation)

**Format **your assignment consistent with APA guidelines.** **

video

**Watch **the instructional video by clicking on the Lynda.com^{®} link.

**Type** the title “Statistics with Excel Part One” in the Search Bar to find the video.

**Watch** the following tutorials from Section 19:

- Two-Factor ANOVA

**Consider** the following as you watch:

- Discover how to perform a two factor hypothesis test with Microsoft
^{®}Excel^{®}

**Watch **the instructional video by clicking on the Lynda.com^{®} link.

**Type** the title “Statistics with Excel Part One” in the Search Bar to find the video.

**Watch** the following tutorials from Section 20:

- Regression Line Overview

**Consider** the following as you watch:

- How can you use Microsoft
^{®}Excel^{®}to create a regression line?

**Watch **the instructional video by clicking on the Lynda.com^{®} link.

**Type** the title “Descriptive Healthcare Analytics in R” in the Search Bar to find the video.

**Watch** the following tutorials from Section 6:

- Introduction to ANOVA and Linear Regression Code

**Consider** the following as you watch:

- Demonstrate what Microsoft
^{®}Excel^{®}statistical tools are needed to produce a linear regression and ANOVA models.

## Place this order or similar order and get an amazing discount. USE Discount code “GET20” for 20% discount