Trident BUS520 Complete Course Latest 2021 December (Full)

BUS520 Business Analytics and Decision Making

Module 1 CASE

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.

 

BUS520 Business Analytics and Decision Making

Module 1 Discussion

Bias, Statistics, News and Lies.

Statistics and Lies

“There are three kinds of lies: lies, damned lies, and statistics.” – Mark Twain.

A mid-twentieth century book: Lessons on How to Lie with Statistics still holds true. 2020 was a year filled with lies and obfuscation which spread like wildfire on social media. What is real? What is fake?

Module 1 Discussion Week 1 Resources

Without learning to think statistically, we’ll never know when people are bending the truth (2020)

3 Ways to Lie with Statistics (2021)

How To Lie With Statistics (2020)

Griggs: Chaos, butterflies, and numbers that lie (2021)

Week 1 Discussion Post

Based on the resources provided or your research, share how studying statistics, data analysis, and decision-making can provide a foundation for detecting lies or poorly supported “facts.” Consider a career/professional application rather than a personal one. (Research Support Required)

This post should be 2 paragraphs in length (150-200 words). Since you are engaging in research, be sure to cite in the body of the post and add a reference list in APA format. NOTE: failure to use research with accompanying in-text citations to support content will result in reduced scoring “Level 2-Developing” on the grading rubric.

WEEK 1 INTERACTIVE RESPONSES TO CLASSMATES

1st Interactive Response:

Analyze one student’s application and compare/contrast it to your post.

2nd Interactive Response:

Analyze another student’s coverage of lies or poorly supported “facts” and compare/contrast it to your post.

Each reply should be one paragraph in length (or about 75 words) and must be substantive. Do not simply say “I agree” or “That is great”; specify why and be detailed in your explanation. You may use research in your responses, but it is not required.

Bias, Statistics and News

You have seen poll results and heard about statistics reported in the news. And there have been instances when two different groups cover the same statistics/data with different results or interpretations. Is one group lying?

 

Module 1 Discussion Week 2 Resources

Why stats in the news don’t often add up – and how to spot a fake (2021)

Polls – can you really believe them? (2021)

The Number Bias by Sanne Blauw review – how numbers can mislead us (2020)

COVID-19, lies, and statistics: corruption and the pandemic (2021)

Coronavirus, and the Media’s Lies, Damned Lies, and Statistics (2020)

Based on the resources provided and internet research, find an example of two different sources promoting opposite points of view when reporting on the same statistics. Analyze how the arguments are laid out. Approach it scientifically rather than allowing bias to guide your interpretation. Provide hyperlinks to both sources. (Research Support Required)

This post should be 2 paragraphs in length (150-200 words). Since you are engaging in research, be sure to cite in the body of the post and add a reference list in APA format. NOTE: failure to use research with accompanying in-text citations to support content will result in reduced scoring “Level 2-Developing” on the grading rubric.

WEEK 2 INTERACTIVE RESPONSES TO CLASSMATES

1st Interactive Response:

Analyze one student’s analysis and point out perceived bias that you see in the post.

2nd Interactive Response:

Analyze another student’s coverage and share how your bias makes you more prone to believe one point of view over another.

Each reply should be one paragraph in length (or about 75 words) and must be substantive. Do not simply say “I agree” or “That is great”; specify why and be detailed in your explanation. You may use research in your responses, but it is not required.

In your own words, respond to the discussion and comments of classmates. Grades will be based on effectual, concise, and interactive feedback. The excessive use of quotes will directly impact performance since this indicates a lack of comprehension and shows that you may not have mastered the concepts.

Why a discussion post and reply each week? Planning and time management are invaluable skills for business professionals who juggle jobs, personal lives, and other endeavors. Coming to terms with balancing priorities in an academic setting is a transferable skill to the workplace. Making optimum decisions about scheduling can help you excel along the career path.

 

 

 

 

 

 

BUS520 Business Analytics and Decision Making

Module 2 Discussion

Was it Real or Fake?

Hypotheses 101

Hypotheses and hypothesis testing are important tools in analysis that use the scientific method. Most of us first learned about the topic for a science project in elementary school. As graduate students and business professionals, the stakes are higher when it comes to the activity.

Module 2 Discussion Week 1 Resources

Did a ‘Stanford/NIH’ Study Conclude Masks Don’t Work? (2021)

Coronavirus laboratory incident hypothesis extremely unlikely: WHO (2021)

How to Tell If People Are Paying Attention on Zoom (2021)

Week 2 Discussion Post

Based on your research, present a hypothesis test scenario you found online. Some of you will be describing a real study that is well-documented and the rest will be crafting fake results for an actual study. The background readings will provide ideas. Describe the study and the results but do not reveal the source, yet.

If your personal phone number ends in an even number, you will present FAKE results; those with an odd number as the last digit will offer a study with REAL results.

This post should be 2 paragraphs in length (150-200 words). NOTE: Research Support Required but it will not be revealed until next week.

WEEK 1 INTERACTIVE RESPONSES TO CLASSMATES

1st Interactive Response:

Select two students’ posts and explain why you think they are REAL. See how well you do…don’t cheat and look for the study.

2nd Interactive Response:

Select two other students’ posts and explain why you think they are FAKE. Wing it…don’t look for the study.

Each reply should be one paragraph in length (or about 75 words) and must be substantive. Do not simply say “I agree” or “That is great”; specify why and be detailed in your explanation. You may use research in your responses, but it is not required.

Were you Fooled?

It’s time for the big reveal. Did you craft an incredible fake and get classmates to believe it? Did you pick a study that was real but was seen as fake by others?

Module 2 Discussion Week 2 Resources

Hypothesis: Milk and Beef ‘Causally Linked’ to Colorectal Cancer (2021)

The “Big Nose Big Hose” Hypothesis Is True, According To Study On Corpses (2021)

There’s a Weird Correlation Between Brain Size And Yawning, Study Reveals (2021)

The Best Times to Trade Forex — Traders Union Research Results (2021)

Title your post: REAL or FAKE. Share the reference information for your study. Critically analyze the actual study. If your study was real, was it well-done? If you faked your results, what did you do to make it believable? (Research Support Required)

This post should be 2 paragraphs in length (150-200 words). Since you are engaging in research, be sure to cite in the body of the post and add a reference list in APA format. NOTE: failure to use research with accompanying in-text citations to support content will result in reduced scoring “Level 2-Developing” on the grading rubric.

WEEK 2 INTERACTIVE RESPONSES TO CLASSMATES

1st Interactive Responses

Reply to one student’s post that you determined was REAL and share if you were right or wrong. Critique the student’s analysis of the study.

2nd Interactive Responses:

Reply to another student’s post that you determined was FAKE and share if you were right or wrong. Critique the student’s analysis of the study.

Each reply should be one paragraph in length (or about 75 words) and must be substantive. Do not simply say “I agree” or “That is great”; specify why and be detailed in your explanation. You may use research in your responses, but it is not required.

In your own words, respond to the discussion and comments of classmates. Grades will be based on effectual, concise, and interactive feedback. The excessive use of quotes will directly impact performance since this indicates a lack of comprehension and shows that you may not have mastered the concepts.

 

BUS520 Business Analytics and Decision Making

Module 3 Discussion

Regression Analysis in Real Life

Regression Basics

What do you know about how regression is used? How can you harness its power to gain an edge in the workplace?

Module 3 Discussion Week 1 Resources

5 Types of Regression Analysis And When To Use Them (2021)

Regression Analysis in Financial Modeling (2021)

What is Regression in Data Mining? (2020)

How to Use Regression Analysis to Forecast Sales: A Step-by-Step Guide (2020)

Week 1 Discussion Post

Based on the resources provided or your research, provide a compelling argument for how regression can be used in your career or profession. (Research Support Required)

This post should be 2 paragraphs in length (150-200 words). Since you are engaging in research, be sure to cite in the body of the post and add a reference list in APA format. NOTE: failure to use research with accompanying in-text citations to support content will result in reduced scoring “Level 2-Developing” on the grading rubric.

WEEK 1 INTERACTIVE RESPONSES TO CLASSMATES

1st Interactive Response:

Analyze one student’s discussion and compare/contrast it to your post.

2nd Interactive Response:

Analyze another student’s use in a specific industry and compare/contrast to how it is used in your discipline.

Each reply should be one paragraph in length (or about 75 words) and must be substantive. Do not simply say “I agree” or “That is great”; specify why and be detailed in your explanation. You may use research in your responses, but it is not required.

Regression Analysis in News Reports

Most people do not understand regression analysis, yet news articles will include discussions supported by the statistical tool. Some examples are provided below.

Module 3 Discussion Week 2 Resources

Yellowstone summers off-the-charts scorching, study says (2021)

Sperm Count Has Decreased By Around 60 Percent In Richer Countries (2021)

The Weak Case Against Repealing Prevailing Wage (2021)

COVID Fake News Detection with a Very Simple Logistic Regression (2020)

Based on your research, present a news article that uses regression for support. Provide a brief description. Rate the ease of understanding of the article’s content. (Research Support Required) Be sure to provide a hyperlink to the article. Do not use the examples provided.

This post should be 2 paragraphs in length (150-200 words). Since you are engaging in research, be sure to cite in the body of the post and add a reference list in APA format. NOTE: failure to use research with accompanying in-text citations to support content will result in reduced scoring “Level 2-Developing” on the grading rubric.

WEEK 2 INTERACTIVE RESPONSES TO CLASSMATES

1st Interactive Response:

Analyze the article presented by one classmate and assess how easily it can be understood by the general public.

2nd Interactive Response:

Analyze the article presented by another classmate and assess how easily it can be understood by the general public.

Each reply should be one paragraph in length (or about 75 words) and must be substantive. Do not simply say “I agree” or “That is great”; specify why and be detailed in your explanation. You may use research in your responses, but it is not required.

In your own words, respond to the discussion and comments of classmates. Grades will be based on effectual, concise, and interactive feedback. The excessive use of quotes will directly impact performance since this indicates a lack of comprehension and shows that you may not have mastered the concepts.

 

BUS520 Business Analytics and Decision Making

Module 4 Discussion

Business Analytics, Intelligence an