Widgets for Which Customers-4–5 pages

The board of directors wants additional information from analysis before making a final decision to move into a line of widgets for the upper Midwest region. Specifically, the board of directors wants to understand if a new line of widgets appeals to a certain age group of consumers. If so, the board of directors may allocate the company’s valuable resources to produce, market, and distribute the new line of widgets to stores within the upper Midwest regions with the goal to obtain the greatest gross profit. The data within the WidgetSpin.xlsx contains the feedback received from a local study.

Your task is to analyze the study’s results and report your findings with a recommendation to the board of directors using Excel and Excel Pivot Tables.

Assignment Requirements:

Create an Excel Pivot Table with the data provided in WidgetSpin.xlsx and WorkingWithExcelPivotTables.docx. Add additional fields to the PivotTable. Customize the data as needed. Calculate the standard deviation and compare to the mean. Based off your analysis, what are your recommendations?

For the Unit 3 assignment, you will research and write a short (4–5 pages for the body section) paper in APA (6th edition) style and format, with a minimum of five references, that covers the following topics:

1. Explain the basic framework of a data analytics project.
2. Explain how bias can enter into spreadsheet models.
3. Demonstrate the basics of pivot tables.
4. Describe how central tendency statistics can help or hinder actions taken by decision-makers.
5. Share your recommendations based off the analysis of your Excel PivotTable work.

**The WidegetSpin.xlsx and WorkingWithExcelPivotTables.docx will be added included as two extra attachments.

Additional study sources:

Use the following required texts found within the ProQuest ebrary for Unit 3 studies:

Use your Microsoft Business Intelligence Tools for Excel Analysts text to read the following:

• Chapter 2: “PivotTable Fundamentals.” pages 19–46.

Use your Data Preparation for Data Mining Using SAS text to read the following:

• Chapter 7: “Exploratory Data Analysis,” pages 83–97.

Use your Data Mining and Statistics for Decision Making text to read the following:

• Chapter 2: “The Development of a Data Mining Study,” pages 25–42.