Data Characteristics/Descriptive Statistics/Probability
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= BSBA 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
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
