Project- Part 1
Graphical Techniques
Purpose of Assignment
The purpose of this assignment is to provide students hands-on experience with summarizing raw data using graphs and charts and interpreting results. Students will also use Excel Pivot Tables and Pivot Charts to summarize raw data. In the era of big data, tools like Pivot Tables and PowerPivot are critical tools to summarize the data.
Assignment Steps
Complete the five exercises on the Microsoft Excel file, "Graphical Techniques Template."
Instructions for Question 1
Step 1: Select the entire table including the headings. Make sure you also select the headings (Projection TV, LCD TV, Plasma TV)
Step 2: Click on the Insert tab on the top of Excel.
Step 3: Click on the column chart dropdown.
Step 4: Select 100% stacked column chart.
Step 5: Make sure you get the legend. If you don't get the legend, then please go back to step 1 above and select the titles AND the data.
Step 6: Give a brief and sensible title to the chart.
Step 7: Optional - Label your Y-axis. Make sure you have as units.
Instructions for Question 2
Step 1: Select the entire table including the headings.
Step 2: Click on the Insert tab on the top of Excel.
Step 3: Click on the Pie Chart option.
Step 4: Once the pie chart gets displayed, right-click on the pie chart and select "Add Data Labels".
Step 5: You will see the number on the pieces of the pie chart. Right-click these numbers and select "Format Data Labels".
Step 6: Under "Format Data Labels", check mark only the Category Name, Percentage, and Show Leader Lines. Uncheck the Value box
Step 7: Close the "Format Data Labels" box.
Step 8: Delete the legend at the bottom of the pie chart.
Instructions for Question 3
Step 1: Click on any one rating.
Step 2: Click on the Insert tab on the top of Excel.
Step 3: Click on PivotTable to left.
Step 4: In the Create PivotTable window, click ok.
Step 5: In the PivotTable fields, drag the Restaurant Ratings to Rows.
Step 6: In the PivotTable fields, drag the Restaurant Ratings to Values.
Step 7: Close the Pivot fields bo on the right.
Step 8: Right-click any number on the pivot table.
Step 9: Click on Sort.
Step 10: Click on From Largest to Smallest.
Step 11: Rename the columns.
Steps for creating a Pivot Bar Chart
Step 1: Click anywhere inside the pivot table
Step 2: On the right, click on PivotChart
Step 3: Click on Column or Bar on the Insert Chart window.
Step 4: Click OK to close the Insert Chart window.
Steps for creating a Pivot Pie Chart
Step 1: Click anywhere inside the pivot table
Step 2: On the right, click on PivotChart
Step 3: Click on Pie on the Insert Chart window.
Step 4: Click OK to close the Insert Chart window.
Step 5: Right-click on the Pie chart.
Step 6: Select Add Data Labels.
Step 7: Right-click on the numbers in the pieces of the pie.
Step 8: Select Format Data labels
Step 9: Check the Category and Percentage boxes.
Step 10: Uncheck the Value box.
Instructions for Question 4
Step 1: Select the entire table Make sure you select the headings too.
Step 2: Click on the Insert tab on the Excel ribbon.
Step 3: Click on the line chart.
Step 4: The line chart should be plotted.
Business Decision Making Project- Part 2
Purpose of Assignment
The purpose of this assignment is for students to build upon the problem or opportunity identified in Part 1 in Week 3. In this part, students will identify the appropriate numerical and graphical techniques of descriptive statistics learned in Weeks 2 and 3 and apply them to further studying their problem or the opportunity. Additionally, students will gain experience in using basic concepts of probability to their research.
Assignment Steps
Use the same business problem/opportunity and research variable you wrote about in Week 3.
Note: Do not actually collect any data; think hypothetically.
Develop an analysis of 1,050 words in which you:
- Identify the types of descriptive statistics (numerical measures) that might be best for summarizing the data, if you were to collect a sample.
- Identify the types of descriptive statistics (graphical measures) that might be best for summarizing the data, if you were to collect a sample
- Analyze the role probability (for example, expected values or finding the probability of incurring a loss, etc.) might play in helping address the business problem.
Format your paper consistent with APA guidelines.
Business Decision-Making Project - Part 3
About Your Signature Assignment
This signature assignment is designed to align with specific program student learning Business Decision-Making Project - Part outcome(s) in your program. Program Student Learning Outcomes are broad statements that Grading Guide describe what students should know and be able to do upon completion of their degree. The signature assignment may be graded with an automated rubric that allows the University to collect data that can be aggregated across a location or college/school and used for program improvements.
Purpose of Assignment
The purpose of this assignment is for students to complete the study they started in Week 3. In this part, students will incorporate all the instructor feedback from Weeks 3 and 4 Business Decision-Making Projects, Parts 1 and 2, and use the inferential statistics concepts learned in Week 4 to complete the assignment. This signature assignment will help students experience the essential elements of a basic statistical study used in business organizations.
Assignment Steps
Resources: Microsoft@ PowerPoint@ and Student Resources Guide
Prepare a 25- to 30-slide Microsoft@ PowerPoint@presentation for the senior management team based on the business problem or opportunity you described in Weeks 3 and 4.
Include on the slides what you would want the audience to see (include appropriate visual aids/layout). In the speaker notes section, include 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.
Include the following in your presentation:
Title slide.
Agenda slide.
Describe the organization, with a brief description.
Explain the business problem or opportunity.
Analyze why the business problem is important.
Identify what variable would be best to measure for this problem and explain why. Is this variable quantitative or qualitative?
Apply data analysis techniques to this problem (tell which techniques should be used: descriptive stats, 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.
References slide (if any source material is quoted or paraphrased throughout the presentation).
Format your paper consistent with APA guidelines.