Ashford BUS308 2020 September Full Course Latest

BUS308 Statistics for Managers

Week 1 Discussion

DQ1 Overview: Data Characteristics/Descriptive Statistics/Probability

Read Lecture 1 and view The Role of Data & Analytics Today (Links to an external site.) video. React to the material in the lecture and video. What is new? Is there anything you found to be unclear? How could you relate these ideas to issues and problems within your degree area?

DQ2 Week 1 Example of Statistical Outcomes

Read Lecture 2. React to the material in the lecture. Is there anything you found to be unclear? How could you use these ideas within your degree area?

DQ3 Week 1 Excel Details

Read Lecture 3. React to the material in this lecture. Is there anything you found to be unclear about setting up and using Excel for these statistical techniques? Looking at the data, develop some descriptive statistics on a variable—other than compa-ratio or salary—you feel might be important in answering our equal pay for equal work question. Interpret your results.

 

BUS308 Statistics for Managers

Week 2 Discussion

DQ1 Overview: Hypothesis Testing / T-tests / F-test

Read Lecture 1. React to the material in the lecture. What is new? Is there anything you found to be unclear? How could you relate these ideas to issues and problems within your degree area?

DQ2 Week 2 Example of Statistical Outcomes

Read Lecture 2. React to the material in the lecture. Is there anything you found to be unclear? How could you use these ideas within your degree area?

DQ3 Week 2 Excel Details

Read Lecture 3. React to the material in this lecture. What is unclear about setting up and using Excel for these statistical techniques? Looking at the data, develop a test for mean differences between the genders on a variable – other than compa-ratio or salary – you feel might be important in answering our equal pay for equal work question. Interpret your results.

 

BUS308 Statistics for Managers

Week 3 Discussion

DQ1 Overview: Multiple Testing / ANOVA / Chi Square

Read Lecture 1. React to the material in the lecture. What is new? Is there anything you found to be unclear? How could you relate these ideas to issues and problems within your degree area?

DQ2 Week 3 Example of Statistical Outcomes

Read Lecture 2. React to the material in the lecture. Is there anything you found to be unclear? How could you use these ideas within your degree area?

DQ3 Week 3 Excel Details

Read Lecture 3. React to the material in this lecture. Is there anything you found to be unclear about setting up and using Excel for these statistical techniques? Looking at the data, present an ANOVA on the differences by grade mean on a variable—other than compa-ratio or salary—you feel might be important in answering our equal pay for equal work question. Interpret your results.

 

BUS308 Statistics for Managers

Week 4 Discussion

DQ1 Overview: Correlation / Regression / Patterns

Read Lecture 1. React to the material in the lecture. What is new? Is there anything you found to be unclear? How could you relate these ideas to issues and problems within your degree area?

DQ2 Week 4 Example of Statistical Outcomes

Read Lecture 2. React to the material in the lecture. Is there anything you found to be unclear? How could you use these ideas within your degree area?

DQ3 Week 4 Excel Details

Read Lecture 3. React to the material in this lecture. Is there anything you found to be unclear about setting up and using Excel for these statistical techniques? Looking at the data, develop a correlation table and regression (either linear or multiple) for a variable—other than compa-ratio or salary—you feel might be important in answering our equal pay for equal work question. Interpret your results.

 

BUS308 Statistics for Managers

Week 5 Discussion

DQ1 Overview: Confidence Intervals/Effect Sizes

Read Lecture 1. React to the material in the lecture. What is new? Is there anything you found to be unclear? How could you relate these ideas to issues and problems within your degree area?

DQ2 Week 5 Example of Statistical Outcomes

Read Lecture 2. React to the material in the lecture. Is there anything you found to be unclear? How could you use these ideas within your degree area?

DQ3 Week 5 Excel Details

Read Lecture 3. React to the material in this lecture. Is there anything you found to be unclear about setting up and using Excel for these statistical techniques? Looking at the data, develop a confidence interval on a variable—other than compa-ratio or salary—you feel might be important in answering our equal pay for equal work question. Interpret your results.

 

BUS308 Statistics for Managers

Week 1 Quiz  

Question 1The probability of either, but not both, of two independent events occurring [P(A or B)]is the sum of their individual probabilities.

  True

  False

 

BUS308 Statistics for Managers

Week 2 Quiz  

Question 1A P-value is the probability of selecting a sample that accurately reflects the population.

  True

  False

 Question 2Typical P-values used in hypothesis testing do not include?

  0.001

  0.01

  0.05

  0.10

BUS308 Statistics for Managers

Week 3 Quiz  

Question 1The Chi Square test requires data that is at least _____ in nature.

  nominal

  ordinal

  interval

  ratio

 Question 2The single factor ANOVA tests for mean differences between 3 or more groups by comparing

  Each population’s variance.

  Each sample’s variance.

  Overall versus average sample variance.

  Overall versus average population variance.

 

BUS308 Statistics for Managers

Week 4 Quiz  

Question 1A Pearson correlation of +1.00 is considered a “perfect positive correlation.” This means….

  the variable values would graph as a perfect vertical line

  the variable values would graph as a perfect horizontal line

  has the line with a positive slope and runs from the lower left to the upper right

  has the line with a positive slope and runs from the upper left to the lower right

 Question 2Since no P-value is available, the t Statistic values are used to determine the statistical significance of each of the variables listed in a regression analysis.

  True

  False

BUS308 Statistics for Managers

Week 5 Quiz  

Question 1The probability that the actual population mean will be outside of a 98% confidence interval is

  1%

  2%

  4%

  5%

 Question 2All statistically significant outcomes have practical significance for decision makers.

  True

  False

BUS308 Statistics for Managers

Week 1 Assignment   

ID            Salary    Compa  Midpoint             Age        Performance Rating        Service Gender                Raise     Degree Gender1                Grade

1              60.2        1.056     57           34           85           8              0              5.7          0              M            E

2              27.7        0.893     31           52           80           7              0              3.9          0              M            B

3              35.5        1.145     31           30           75           5              1              3.6          1              F              B

4              56.1        0.985     57           42           100         16           0              5.5          1              M            E

5              48.9        1.018     48           36           90           16           0              5.7          1              M            D

6              74.1        1.106     67           36           70           12           0              4.5          1              M            F

Do not manipuilate Data set on this page, copy to another page to make changes                                                                            

The ongoing question that the weekly assignments will focus on is:  Are males and females paid the same for equal work (under the Equal Pay Act)?                                                                                                         

Note: to simplfy the analysis, we will assume that jobs within each grade comprise equal work.                                                                                

The column labels in the  table mean:                                                                                                    

ID – Employee sample number                                  Salary – Salary in thousands                                                       

Age – Age in years                                           Performance Rating - Appraisal rating (employee evaluation score)                                                        

Service – Years of service (rounded)                                       Gender – 0 = male, 1 = female                                                  

Midpoint – salary grade midpoint                                             Raise – percent of last raise                                                        

Grade – job/pay grade                                  Degree (0= BS\BA 1 = MS)                                                          

Gender1 (Male or Female)                                          Compa-ratio - salary divided by midpoint                                                             

Week 1: Descriptive Statistics, including Probability                                                                                                                                         

While the lectures will examine our equal pay question from the compa-ratio viewpoint, our weekly assignments will focus on examining the issue using the salary measure.                                                                                                                                            

                                                                                                                                                                                                                               

BUS308 Statistics for Managers

Week 2 Assignment   

Week 2: Identifying Significant Differences - part 1                                                                                                                                                                                                                                                                          

To Ensure full credit for each question, you need to show how you got your results.  This involves either showing where the data you used is located                      

or showing the excel formula in each cell.             Be sure to copy the appropriate data columns from the data tab to the right for your use this week.                                                                                                                                

As with our examination of compa-ratio in the lecture, the first question we have about salary between the genders involves equality - are they the same or different?

What we do, depends upon our findings.                                                                                                                                                                                                                                                                                                            

1              As with the compa-ratio lecture example, we want to examine salary variation within the groups - are they equal?                Use Cell K10 for the Excel test outcome location.

                a              What is the data input ranged used for this question:                                                                                                                   

                b             Which is needed for this question:  a one- or two-tail hypothesis statement and test ?                                                                   Answer:                                                                                                                                                              

                                Why:                                                                                                                                                                                                                                                                                    

                What is your conclusion about the variance in the population for male and female salaries?                                        

 

BUS308 Statistics for Managers

Week 3 Assignment   

Week 3: Identifying Significant Differences - part 2                          

To Ensure full credit for each question, you need to show how you got your results.  This involves either showing where the data you used is located                                                                                      

or showing the excel formula in each cell.                                             Be sure to copy the appropriate data columns from the data tab to the right for your use this week.                                                                 

1              A good pay program will have different average salaries by grade.  Is this the case for our company?                                                                                                                                      

                a              What is the data input ranged used for this question:                                                                     Use Cell K08 for the Excel test outcome location.                      

                Note: assume equal variances for each grade, even though this may not be accurate, for purposes of this question.                                                                                                                               

                b.    Step 1:          Ho:                                                                                                                                                                                                                                                                                                                                                                                                                        

What is your conclusion about the means in the population for grade salaries?                                                                                  

2              If the null hypothesis in question 1 was rejected, which pairs of means differ?                                                                                                                                                                  

                (Use the values from the ANOVA table to complete the follow table.)                                                                   

                                                                                                                                                                                                                                               

BUS308 Statistics for Managers

Week 4 Assignment                                 

Week 4: Identifying relationships - correlations and regression                                                                                                                                                                                                                                                                                  

To Ensure full credit for each question, you need to show how you got your results.  This involves either showing where the data you used is located                      

or showing the excel formula in each cell.                             Be sure to copy the appropriate data columns from the data tab to the right for your use this week.              

                                                                                                                                                                                               

1              What is the correlation between and among the interval/ratio level variables with salary?  (Do not include compa-ratio in this question.)                   

                a. Create the correlation table.                                                                                                  Use Cell K08 for the Excel test outcome location.

                i.                                                                              What is the data input ranged used for this question:                                                                                                                    

                ii.             Create a correlation table in cell K08.                                                                                                                                                                     

                b. Technically, we should perform a hypothesis testing on each correlation to determine                                                             

                                               

BUS308 Statistics for Managers

Week 5 Assignment   

Final Paper

The Final Paper provides you with an opportunity to integrate and reflect on what you have learned during the class.

The question to address is: “What have you learned about statistics?” In developing your responses, consider—at a minimum—and discuss the application of each of the course elements in analyzing and making decisions about data (counts and/or measurements).

In your paper,

Discuss the following course elements:

Descriptive statistics

Inferential statistics

Hypothesis development and testing

Selection of appropriate statistical tests

Evaluating statistical results.

The Final Paper

Must be three to five double-spaced pages in length (not including title and references pages) and formatted according to APA style as outlined in the Ashford Writing Center (Links to an external site.).

Must include a separate title page with the following:

Title of paper

Student’s name

Course name and number

Instructor’s name

Date submitted