statistics

There is more info that may be needed form previous assignments and please use apa format and cite the sources. at least3 or more scholarly sources

This class is different from most in the MBA program because you have a big, 300 point, final project! The description is in the Course Materials folder for Unit 1. I need to also correct the point total from the course syllabus. There are 1025 points in this class rather than the 800 you normally have in other classes. If you happen not to score well early in the class, the final project and the extra 300 points will give you an opportunity to make up lots of points!

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!

I

A few housekeeping notes..
You do not need approval for your final project if you are using one of Dr. Mirabella’s data sets or data from a government site. The final project is worth more than the other Complete assignments because you will pull from all of the prior units.

You will submit ONE document including your summary and charts – you can copy and paste our charts in your assignment or use screen prints (either way works just fine). You can use the charts as an appendix or you may include them in your discussion.

All Excel output should be copied into a single Word document where you must enter all of your responses to the questions below. Format the document professionally so it flows well. Include a table of contents.

* Choose any published database from the internet or Bethel library (such as those from the Census Bureau or any financial sites). You may opt to use one of the data files provided by the instructor if applicable.

* Get advanced approval from the instructor on your chosen database.

* If the file is large, randomly choose 200 of the observations from the data.

* Explain each variable in the file that you are analyzing. Be sure your file includes at least 3 scale variables and at least 2 nominal variables.

* Conduct a descriptive analysis on any 2 interval / ratio variables you wish using Descriptive_Statistics.xls and Frequency_Distribution.xls. Explain the output.

* Conduct 3 different hypothesis tests of your choice using appropriate variables from the file (note: you must use 3 different tests and not run one test on 3 different variables). In each case, state the variables