01 Oct Professional Application with Excel
Business Analytics and Decision Making
DESCRIPTIVE STATISTICS AND VISUAL DISPLAYS
Assignment Overview
Professional Application with Excel
Critical thinking and analysis are valuable skills for professionals in any industry. Exploring data can include financials, sales figures, benchmarks, or survey results. While data is everywhere, it is meaningless unless we can use it to support decision-making.
Tables, graphs, and output from Excel may be non-sensical. This is where the analyst comes in; their knowledge and expertise are used to interpret results. If a visual or output cannot be easily explained, then it may not be useful.
Case 1 Resources
Load the Analysis ToolPak in Excel
Available chart types in Office
Analyze Data in Excel
Differences between histograms and bar charts
How to Label Figures in APA Format
Case Assignment
Industry Research and Analysis with Excel
Research the industry listed in the Excel sheet. Using a US Industry Report in IBISWorld’s Industry Research, provide a one-page background of the industry. Find a balance between explanations, data and statistics provided. You must decide what information should be included in this section.
(IBISWorld Research support required) This section must be one page in length.
Next, create a histogram for each of the four survey measures. Describe the skew and spread. Make connections between analysis of each histogram and the “descriptives” from Module 1 SLP. Using research on the state of the industry, provide rationale for the results. (Research support required)
Finally, use Analyze Data in Excel. Select three of the suggestions and add them to this report.
Insert Chart in Word.
Describe the findings. Link to information from “descriptives.”
Discuss implications for the industry. (Make connections with the research from IBISWorld).
Case 1 Assignment Guidance Files
BUS520 Case 1 Assignment Video Guidance BUS520 Case 1 Assignment Guide
No quotations are permitted in this paper. Since you are engaging in research, be sure to cite and reference the sources in APA format. NOTE: failure to use research with accompanying citations to support content will result in reduced scoring “Level 2-Developing” across the grading rubric. This is a professional paper; not a personal one based on feelings. It must be written in the third person; this means words like “I”, “we”, and “you” are not appropriate.
This is the Data set that will be used for class.
If you procure old assignments from students or websites and use the data for your assignment, you will receive a zero because it is considered a violation of the University’s academic integrity policy. The case will be referred and become part of your collegiate record. In certain circumstances, you may be awarded an F for the course.
If you are taking this class for a second time, submission of past work involving the data sets will result in a zero for the assignment. Your answers will be wrong since you are working with a different set of numbers and a different industry.
BUS520 Business Analytics and Decision Making
Module 1 SLP
DESCRIPTIVE STATISTICS AND VISUAL DISPLAYS
Professional Application with Excel
Excel is a powerful tool that supports data analysis and provides managers with support for making decisions. Mastering Excel functions is an important step in the process.
Session Long Project 1 Resources
COUNTIF function
Available chart types in Office
Load the Analysis ToolPak in Excel (You will need this)
Use the Analysis ToolPak to perform complex data analysis (Descriptive Statistics)
What is a pie chart?
The story you want to tell…and the one your data shows
How to Label Figures in APA Format
SLP Assignment
Data Analysis with Excel
Use the Excel Data found in Module 1 Case.
Create the following visuals using Excel for the survey Demographics:
Gender- Pie Chart
Age-Pie Chart
Department-Column Chart
Position- Bar Chart
Tenure- Bar Chart
Provide a one-sentence description of each visual. How to Label Figures in APA Format
SLP 1 Assignment Guidance Files (Part 1)
BUS520 SLP 1 Assignment Video Guidance Part 1 BUS520 SLP 1 Assignment Guide Part 1
Run “Descriptives” for each of the four Survey Measures:
Job Satisfaction
Intrinsic Job Satisfaction
Extrinsic Job Satisfaction
Organizational Commitment
Research the four survey measures and provide definitions (1-2 sentences each).
Select the best “descriptives” for each survey measure and analyze them. (2 minimum per measure, for a total of 8)
Explain why the measures were chosen. (Research support required)
SLP 1 Assignment Guidance Files (Part 2)
BUS520 SLP 1 Assignment Video Guidance Part 2 BUS520 SLP 1 Assignment Guide Part 2
No quotations are permitted in this paper. Since you are engaging in research, be sure to cite and reference the sources in APA format. NOTE: failure to use research with accompanying citations to support content will result in reduced scoring “Level 2-Developing” across the grading rubric. This is a professional paper; not a personal one based on feelings. It must be written in the third person; this means words like “I”, “we”, and “you” are not appropriate.
BUS520 Business Analytics and Decision Making
Module 2 CASE
HYPOTHESIS TESTING: T-TESTS & ANOVAS
Assignment Overview
Hypothesis Tests & ANOVA
One-Way ANOVA (Analysis of Variance) tests if there are statistical differences between the means of three or more independent groups.
Case 2 Resources
Analysis of Variance (ANOVA)
Single factor ANOVA in Excel or one way ANOVA in Excel Explained
Perform a One-Way Analysis of Variance (ANOVA) in Excel
Case Assignment
Industry Research and Analysis with ANOVA
In Case 1, you used Analyze Data in Excel and it provided suggestions about the data. For this case, you will be using ANOVAs to look for differences.
Wording for ANOVAs:
(Null Hypothesis) H0: There is no difference in Survey Measure by Demographic.
(Alternate Hypothesis) H1: There is a difference in Survey Measure by Demographic.
Based on what you discovered in Analyze Data, see if there are differences in the four survey measures by one demographic (other than gender).
Insert Chart in Word.
Describe the findings.
Write the Null & Alternative Hypotheses.
Run the ANOVA Test, α = 0.05 level.
Reject or Fail to Reject the Null Hypothesis.
Discuss implications for management. Research and find out if there are studies that make connections between the variables you tested (or similar ones).
Make industry connections with the research from IBISWorld. Include workplace applications that may be implemented based on the findings.
Run a total of 3 ANOVAs for this assignment.
Case 2 Assignment Guidance Files
BUS520 Case2 Assignment Video Guidance
BUS520 Case 2 Assignment Guide
No quotations are permitted in this paper. Since you are engaging in research, be sure to cite and reference the sources in APA format. NOTE: failure to use research with accompanying citations to support content will result in reduced scoring “Level 2-Developing” across the grading rubric. This is a professional paper; not a personal one based on feelings. It must be written in the third person; this means words like “I”, “we”, and “you” are not appropriate.
BUS520 Business Analytics and Decision Making
Module 2 SLP
HYPOTHESIS TESTING: T-TESTS & ANOVAS
Assignment Overview
Two Sample Hypothesis Tests
Comparing two samples provides insights. Are employees with an MBA more productive than those without? If our results support the contention, then hiring more MBAs would be good for business.
Session Long Project 2 Resources
Hypothesis Testing: Two Samples
Two Sample T-Test Equal Variance
T Test in Excel
SLP Assignment
Writing & Testing Hypotheses
Is job satisfaction in our industry the same for both genders? We will look at Job Satisfaction and Gender for this analysis. First, we write out the hypotheses:
(Null Hypothesis) H0: μ1 – μ2 = 0
(Alternate Hypothesis) H1: μ1 – μ2 ≠ 0
H0: Males rate job satisfaction the same as females.
H1: Males rate job satisfaction differently than females.
You decide to test this at the α = 0.05 level, using a t-Test: Two-Sample Assuming Unequal Variances. Run this test in Excel and interpret the results.
p-VALUE approach (use the wording to reject or fail to reject the Null hypothesis)
Given that the p value (xx) is greater than the alpha (.05), the Null hypothesis cannot be rejected, therefore there is no support for the Alternate Hypothesis that (paste Alternate Hypothesis)
OR
Given that the p value (xx) is less than the alpha (.05), the Null hypothesis is rejected, therefore there is support for the Alternate Hypothesis that (paste Alternate Hypothesis here)
Discuss implications for management. Research and find out if there are studies that make connections between the variables you tested.
Make industry connections with the research from IBISWorld. Include workplace applications that may be implemented based on the findings.
Repeat the same testing for:
Intrinsic Job Satisfaction
Extrinsic Job Satisfaction
Organizational Commitment
SLP 2 Assignment Guidance Files
BUS520 SLP2 Assignment Video Guidance
BUS520 SLP 2 Assignment Guide
No quotations are permitted in this paper. Since you are engaging in research, be sure to cite and reference the sources in APA format. NOTE: failure to use research with accompanying citations to support content will result in reduced scoring “Level 2-Developing” across the grading rubric. This is a professional paper; not a personal one based on feelings. It must be written in the third person; this means words like “I”, “we”, and “you” are not appropriate.
BUS520 Business Analytics and Decision Making
Module 3 CASE
CORRELATION REGRESSION ANALYSIS
Assignment Overview
Regression Analysis
This is your final data analysis project in class. You have become very familiar with the data and have a number of findings that may assist in managerial decision-making. The goal is to find what type of relationship exists between variables.
Case 3 Resources
Application of Regression Analysis in Business
Regression Basics for Business Analysis
Response variables
Predictor variables
How to Perform Regression Analysis using Excel
Case Assignment
Regression Analysis
Based on what you have learned from the data, generate a simple regression using variables of your choosing at 95% confidence interval. Explain why the two variables were chosen and why one is the dependent variable, and the other is the independent variable. Include the regression output in your paper.
Interpret the following:
R Square
Adjusted R Square
Standard Error
ANOVA Table
Coefficients Table
Case 3 Assignment Guidance Files
BUS520 Case 3 Assignment Video Guidance BUS520 Case 3 Assignment Guide
Discuss implications for management. Include workplace applications that may be implemented based on the findings. (Research Required)
Generate a multiple regression using variables of your choosing at 95% confidence interval. Explain why the variables were chosen and why one is the independent variable, and the others are independent variables. Include the regression output in your paper.
Interpret the following:
R Square
Adjusted R Square
Standard Error
ANOVA Table
Coefficients Table
Discuss implications for management Include workplace applications that may be implemented based on the findings. (Research Required)
No quotations are permitted in this paper. Since you are engaging in research, be sure to cite and reference the sources in APA format. NOTE: failure to use research with accompanying citations to support content will result in reduced scoring “Level 2-Developing” across the grading rubric. This is a professional paper; not a personal one based on feelings. It must be written in the third person; this means words like “I”, “we”, and “you” are not appropriate.
BUS520 Business Analytics and Decision Making
Module 3 SLP
CORRELATION REGRESSION ANALYSIS
Assignment Overview
Correlation and Scatterplots
Let us delve into Organizational Commitment. In your earlier research, you discovered how important this is to a company. Now, we will investigate what types of correlations exist between Organizational Commitment and the three measures of job satisfaction.
Session Long Project 3 Resources
What is a scatterplot?
Thoughts on trendlines
Present your data in a scatter chart or a line chart
Using Excel to Calculate Correlation
What Do Correlation Coefficients Positive, Negative, and Zero Mean?
SLP Assignment
Organizational Commitment
Run a correlation in Excel between Organizational Commitment and Overall Job Satisfaction. Create a Scatterplot with trendline for the variables. Interpret the output. How is the data correlated? Is it a strong relationship? (Include Correlation and Scatterplot in Word document)
Run a correlation in Excel between Organizational Commitment and Intrinsic Job Satisfaction. Create a Scatterplot with trendline for the variables. Interpret the output. How is the data correlated? Is it a strong relationship? (Include Correlation and Scatterplot in Word document)
Run a correlation in Excel between Organizational Commitment and Extrinsic Job Satisfaction. Create a Scatterplot with trendline for the variables. Interpret the output. How is the data correlated? Is it a strong relationship? (Include Correlation and Scatterplot in Word document)
SLP 3 Assignment Guidance Files
BUS520 SLP 3 Assignment Video Guidance BUS520 SLP 3 Assignment Guide
Discuss implications for management. Research correlations between organizational commitment and job satisfaction connections between the variables you tested. Include workplace applications that may be implemented based on the findings. (Research Required) 1 page
No quotations are permitted in this paper. Since you are engaging in research, be sure to cite and reference the sources in APA format. NOTE: failure to use research with accompanying citations to support content will result in reduced scoring “Level 2-Developing” across the grading rubric. This is a professional paper; not a personal one based on feelings. It must be written in the third person; this means words like “I”, “we”, and “you” are not appropriate.
BUS520 Business Analytics and Decision Making
Module 4 CASE
BUSINESS ANALYTICS & INTELLIGENCE REPORTING
Assignment Overview
Presentation
You compiled a comprehensive report based on the findings for the Module 4 Session Long Project. It included workplace applications that may be implemented based on the findings. You will present your findings to industry leaders.
Case 4 Resources
Presentation Tips to Improve Your Data Science Communication Skills
Overcoming Obstacles in Your Presentation
Functions of the Presentation to Persuade
Developing Pitches for Various Audiences and Goals
Case Assignment
Presentation
You will deliver your presentation by video.
You may use visuals like graphs to deliver the message.
Write a 250- to 350-word document that is the basis of your presentation.
3- to 3½-MINUTE VIDEO
You can talk about the same content that is written but do not read it. Impromptu speaking has a different impact than reading from a screen.
It is up to you to decide what information should be covered in the time allowed. Content beyond 3½ minutes will not be viewed or considered.
BUS520 Business Analytics and Decision Making
Module 4 SLP
BUSINESS ANALYTICS & INTELLIGENCE REPORTING
Assignment Overview
Final Analysis
We have been working with survey data throughout class. Create a final report that can be used by industry leaders. Data analysis is transformed to business intelligence. This is where you make the tough decisions. What analysis should be included in the final report?
Session Long Project 4 Resources
Survey data analysis: Best practices, helpful tips, and our favorite tools
How to write a well-structured, informative data analysis report
What’s the best way to share your findings with stakeholders?
Six Best Practices for Creating Effective and Engaging Reports
Assignment Expectations
Report Compilation
Add an Executive Summary that fully connects all of your pertinent findings. (This will be written last)
Create a final report that is made up of selected content from Modules 1-3.
Fully analyze the results of the survey and include managerial implications.
Include workplace applications that may be implemented based on the findings.
SLP 4 Assignment Guidance Files
BUS520 SLP 4 Assignment Video Guidance BUS520 SLP 4 Assignment Guide
No quotations are permitted in this paper. Since you are engaging in research, be sure to cite and reference the sources in APA format. NOTE: failure to use research with accompanying citations to support content will result in reduced scoring “Level 2-Developing” across the grading rubric. This is a professional paper; not a personal one based on feelings. It must be written in the third person; this means words like “I”, “we”, and “you” are not appropriate.
