statistics

statistics

Please use apa format and make sure to cite with scholarly sources. A quick review of how to complete the course. Watch the Attend. Read the Chapter. Go to Dr. M’s website (http://www.drjimmirabella.com/Bethel/) download the “Excel Data File – Student Data” because you will use this a lot (download it from Dr. M’s website). Work the sample problem for the Unit. Then work the assigned Complete problem. You will be copying and pasting columns of data for the Complete assignments into the Excel spreadsheets provided by Dr. M. Look for the yellow highlighted cells – these are the ones where you will be entering information.

Okay, so here are some very important tips for being successful in the class:

1) Make sure you save every Excel file that you are going to upload to the Dropbox using your name and the unit number as the file name. (for example, I might save mine as CAMPBELL Unit 1.

2) Be very careful about copying and pasting in the spreadsheets. If you copy and paste cells from one spreadsheet to another you WILL end up with wrong answers! Dr. M has a lot of equations that are “hidden” that you will lose if you just copy and paste cells.

3) EVERY BOX in the Complete assignment MUST answer 3 questions

a) DEFINE WHAT YOU ARE DOING. This is NOT a step by step description of your actions. This is where you define and explain the statistics you are going to run to answer the question. For example, What is a categorical analysis? Why run it? What will it tell you? What variables are you going to use to run it? Show me that you know what you are running.

b) REPORT THE RESULTS. This is the EASY one. Everyone should get this one right every time! All you have to do is report the results using the appropriate “statistical terminology” that Dr. M has shown you in the text and in the Attend (yes, you should read and watch these!).

c) INTERPRET THE RESULTS. This one is NOT the same as reporting the results. No, NO, NO! Here you are going to explain what the results are telling us. What do they MEAN? What conclusions can we draw from the results? This is a critical part of the answer EVERY TIME! That’s because the point of the class is to make sure you can USE statistics. You show you can use them by (being able to explain why you use them in A above) being able to EXPLAIN what the results MEAN – that’s more than just reading the numbers that Excel spits out. For example, let’s say the results of your analysis say that there is a statistically significant difference between the GPAs of males versus females. If you say “I accept the alternative hypothesis that GPAs are different for males and females” that is NOT a good answer! All that answer did was restate the results. You MUST go on and explain what that result MEANS – INTERPRET it for me based on the information you have. So you might go on and say something like, “males tend to have higher GPAs than females. This may be true because males tend to work fewer hours than females and therefore they have more time to study.” That’s an interpretation – it may take a little creativity and it will take a reading of the chapter and watching the Attend as well as knowing your dataset. (And by the way, I made that up – that result or interpretation is not necessarily true!!

4) Access the data file from Dr. M’s website. Don’t use the link that is provided in the Complete assignment! Dr. M’s data file is a little different from the one that is in the Complete assignment. Dr. M’s is the one that is up to date. Here’s the biggest difference: when you do the Complete assignments the coding for gender is 0=MALE, 1=FEMALE. Always use this coding. The data file on Dr. M’s site uses this coding. The data file from the Complete does not!

5) The Final Project is just a repeat of some of the stats you will have run by doing the Complete assignments. You will still be answering the same 3 questions again! This means it is very important that you spend the time on the front end of the class getting each Complete assignment right. IF you do, the Final Project will be very easy! If you don’t work to get it correct the first go through, you’ll have a long and frustrating last week of the class!

1.Historically, the MBA program at Whatsamattu U. has about 40% of their students choose a Leadership major, 30% choose a Finance major, 20% choose a Marketing major, and 10% choose no major. Does the most recent class of 200 MBA students fit that same pattern or has there been a shift in the choice of majors. Using the sample of 200 students (in the data file), conduct a Chi Square Goodness of Fit test to determine if the current distribution fits the historical pattern. Use a .05 significance level.

2.While job opportunities for men and women are considerably more balanced than they were 40 years ago, the career aspirations may still differ. Is there a difference in majors chosen by men and women? Using the sample of 200 MBA students (in the data file), conduct a Chi Square Test of Independence to determine if one’s choice of major is independent of their gender. Use a .05 significance level.