Statistical Case Study - MBA Salaries
kvillamarin
Case2Examplestepbystep.docxCases step by step: Case 2 Example MMG525OL01 Summer 2020
Help File for Stats Case 2: MBA Salaries
Each case will have a story in the text and usually uploaded as a pdf file as well. Here is how I approach a Case Study Exercise.
1. Find and read or download and read the “story”. Our example here with be Case 2. I use Coursework to find what I am looking for but Overview also works. Both give a sequential and chronological look at all the work:
2.
3. Note in Week 4, the 2nd Assignment down is: Case 2 MBA Salaries: A Representative Sample. You want to click on that. Note that right away you are getting clues to solve the case since the key words are “Representative” and “Sample”. It seems like the task will be to create a random (not biased) sample (part) of the whole thing we are interested in: 100 MBA salaries. The suggestion is to devise a random sampling method (I picked every 10th number in the data base), run the basic statistical tests on it and then see if the sample you created is representative (close to) the stats we already have reported about the whole group of 100 salaries in the text.
4.
5. Here is what you will see when you click on the Case 2 Assignment:
This case studies is included in your final grade and is scored out of 5 points.
Notes on Case 2: The Case File to fill out and upload is below.
p. 188, -Devise a random sample for the 100 data set shown on p.118 in Pelosi; Put your response into the Case 2 Spreadsheet .xls; calculate (w/ formulas): mean, median, mode, range, SD (Standard Deviation). Compare to population stats.
1. p. 118. The data set is 100 salaries.
2. An Administrator thinks the advertised median salary of MBAs is not representative. Is she correct in her thinking? Should the college make a decision about changing the information they give out about graduates?
3. Task: devise a random sampling method. Select 20 of the 100 salaries. [One way—use =RAND() formula]. Perform calculations on your Excel sheet on the sample of 20 for: mean, median, mode, range, SD. Compare to their population stats. How representative was your sample? How valid the sampling method?
Files:
This File is: Case 2 Example, step by step.
You must upload at least 1 file
Your assignments
Case 2 MBA Salaries: Representative Sample? Case Studies in Week 4
So, you want all 3 files including the data set of 100 MBA salaries (Pelosi, p.118) if you don’t have the text.
2
1
Cases step by step
: Case 2 Example MMG525
O
L01 Summer 20
20
Help File for Stats Case 2: MBA Salaries
Each case will have a story
in the text and usually uploaded as a pdf file as
well. Here is how I approach a Case Study Exercise.
1.
Find and read or download and read the “story”. Our example
here
with be Case 2. I use Coursework to find what I am looking for but
Overview also works. Both give a sequential and chronological look
at all the work:
2.
3.
Note in Week 4, the 2
nd
Assignment down is: Case 2 MBA Salaries: A
Representative Sample. You want
to click on that. Note that right
away you
a
r
e
getting clues to solve the case since the key words are
“
Representative”
and “
Sample”.
It seems like the task will be to create
a random (not biased) sample (part) of the whole thing we are
interested in: 100
MBA salaries. The suggestion is to
devise a
random sampling method
(I picked every 10
th
number in the data
base), run the basic statistical tests on it and then see if the sample
you created is representative (close to) the stats we already have
reported
about the whole group of 100 salaries in the text.
4.
5.
Here is what you will see when you click on the Case 2 Assignment:
This case studies is
included in your final grade
and is scored out of
5 points
.
Notes on Case 2: The Case File to fill out and upload
is below.
p. 188,
-
Devise a random sample for the 100 data set shown on p.118
in
Pelosi
; Put your response into the Case 2 Spreadsheet .xls; calculate (w/
1
Cases step by step: Case 2 Example MMG525OL01 Summer 2020
Help File for Stats Case 2: MBA Salaries
Each case will have a story in the text and usually uploaded as a pdf file as
well. Here is how I approach a Case Study Exercise.
1. Find and read or download and read the “story”. Our example here
with be Case 2. I use Coursework to find what I am looking for but
Overview also works. Both give a sequential and chronological look
at all the work:
2.
3. Note in Week 4, the 2
nd
Assignment down is: Case 2 MBA Salaries: A
Representative Sample. You want to click on that. Note that right
away you are getting clues to solve the case since the key words are
“Representative” and “Sample”. It seems like the task will be to create
a random (not biased) sample (part) of the whole thing we are
interested in: 100 MBA salaries. The suggestion is to devise a
random sampling method (I picked every 10
th
number in the data
base), run the basic statistical tests on it and then see if the sample
you created is representative (close to) the stats we already have
reported about the whole group of 100 salaries in the text.
4.
5. Here is what you will see when you click on the Case 2 Assignment:
This case studies is included in your final grade and is scored out of 5 points.
Notes on Case 2: The Case File to fill out and upload is below.
p. 188, -Devise a random sample for the 100 data set shown on p.118
in Pelosi; Put your response into the Case 2 Spreadsheet .xls; calculate (w/
