Module 6 - Assignment: Quantitative Data Analysis Assignment

Question # 00389091 Posted By: lola1 Updated on: 09/18/2016 02:27 AM Due on: 09/18/2016
Subject Business Topic Management Tutorials:
Question
Dot Image


Module 6 - Assignment: Quantitative Data Analysis Assignment

Download the Quantitative Data Analysis Assignment Document and save it to your computer. This assignment will require you to first select a sample, and then work problems related to analyzing the data from that sample.

  • Quantitative Data Analysis Assignment

Work through the problems in the assignment using StatCrunch software and insert your answers to each of the problems in the space below the problem statement. Be sure to include appropriate output from StatCrunch as a part of your answer; remember, you also need to clearly answer each question in your own words.


The StatCrunch Instructions documents for chapter 14 and 15 below have step-by-step instructions on using StatCrunch for the Quantitative Data Analysis Assignment. There are two versions of StatCrunch, called Classic StatCrunch and New StatCrunch. Classic StatCrunch requires a Java plugin. New StatCrunch was developed to work with more recent browsers and does not require Java. There are instruction files for the two chapters for each version of StatCrunch. If you are using a relatively new computer and browser or an Ipad, tablet, or MAC, you should try New StatCrunch first. If you have an older computer or browser, you might want to try Classic StatCrunch first. You can change later if needed. Instructions for choosing the version of StatCrunch you want to use and changing versions are in the StatCrunch instructions files below.


  • New StatCrunch instructions for chapter 14
  • New StatCrunch instructions for chapter 15
  • Classic StatCrunch instructions for chapter 14
  • Classic StatCrunch instructions for chapter 15

NOTE: Do NOT delay working on this assignment! It is due next week in Module 7, and, depending on your familiarity with statistics and the use of StatCrunch, it may take you several hours to complete.


In this assignment, you will be required to download data and then use techniques from descriptive and inferential statistics to analyze that data. The following sets the scenario for the data set that you will download.

StatCrunch U is a fictitious university made up of 46,000 students (the population). Each student completed the survey shown here:

That gives us a data base with that information for all 46,000 students.

For this assignment, you will first select a sample of 200 students from this population and then analyze the data from the sample to draw conclusions about the entire population of StatCrunch U students. The following instructions tell you how to select your sample.

Log in to StatCrunch.com and click on Resources at the top of the page, then on StatCrunch U on the left side. You should see the following paragraph.

Click on the StatCrunchU link in the paragraph above.

In the next screen, scroll down until you see the following, set the sample size to 200, and click Survey.

Your sample with the survey data should then show on theStatCrunch screen as shown below. If you don’t see the file, click MyStatCrunch, then My Preferences, then make sure classic StatCrunch is chosen. After that, try doing the survey. Be sure to click on Data>Save data and save the file to your My Data folder.

You should see a menu like the one below where you can give the file a name. Click on Save and you should get confirmation that the file was saved.

Next go to your StatCrunch My Data folder and find the file so that you can work with it to answer the following questions. Each question is worth 10 points.

1. Copy and paste the first 15 rows from your StatCrunch data file below. You can do that by highlighting the data in StatCrunch, then clicking on Edit>Copy. Next return to this file, place your cursor in the space below, and click Paste. The purpose of this is to allow your instructor to see the first part of your data set.Use all 200 students in your sample to answer the remaining questions.

2. What is the shape of the distribution of credit hours? Compute summary statistics and use StatCrunch to construct a histogram of the credit hour data. Include a short paragraph answering the question.

3. Suppose you want to construct a 95% confidence interval for the mean credit hours taken by StatCrunch U students. What sample size would be needed to limit the margin of error to 0.5 credit hours? Use the sample standard deviation from your sample as an estimate of the population standard deviation. You will need to follow the example on page 266 of the text.

4. (a) What is the proportion of females at StatCrunch U? Create a pie chart showing the proportion of female students at StatCrunch U. Be sure to include a couple of sentences answering the question.

(b) Does the proportion of females change across classes? Create a stacked bar chart and a contingency table to show how the proportion changes across classes. Make sure your bar chart shows proportions or percentages, not counts. Be sure to include a couple of sentences answering the question.


5. Does the number of credit hours taken vary depending on whether or not students work? Create two boxplots on the same set of axes showing the number of credit hours taken by students who work and by students who do not work. Describe the distributions and any similarities or differences.

To do this in StatCrunch, you will first need to create an additional column in your data file that indicates whether or not a student works. You can do that in StatCrunch by using the Data>Bin column command as shown to the right and explained below. You will need to use the column you create here in problems 7, 8, and 10 also.

With your StatCrunch U file open, go toStatCrunch>Data>Bin Columns and complete the menu as shown to the right. Then click Calculate. This will create a new column titled Bin(Work) in the StatCrunch file. In that column working students will be labeled, “0.1 or above.” See below.

Go to StatCrunch/Graphics/ Boxplot and set up the boxplot menu as shown to the right, and click Create Graph! Be sure to include the graph in your paper and also include a few sentences answering the question.

6. Does the mean number of credit hours taken by all students appear to be significantly below 15? Use StatCrunch to conduct a one-sample t-test. Be sure to state the null and alternate hypotheses, include the output from StatCrunch, and briefly answer the question including justification for your answer.

7. For students who work, are there differences in the average loan amounts across classes? Use StatCrunch to conduct an ANOVA test to answer this question. Be sure to state the null and alternate hypotheses, include the output from StatCrunch, and briefly answer the question.

To set up this problem in StatCrunch, you will need to use the Bin(Work) column you created in Problem 5. Go to STAT>ANOVA>One Way, and complete the menu as shown to the right.


8. For students that work, is there a relationship between the dollar amount of loans they have and the number of hours per week that they work?

To set up this problem, you will need to use the Bin(Work) column you created in Problem 5. Open the StatCrunch U file and go to Stat>Regression>Simple Linear as shown to the right. In the menu that appears, select the x-variable, the y-variable, and complete the “Where” entry as shown. Include the StatCrunch output in your paper and be sure to briefly answer the question and explain your answer.

· Construct a scatter plot with Work Hours on the x-axis and Loan Amount on the y-axis.

· Compute the coefficient of correlation, the coefficient of determination, and the linear regression equation.

· Does there appear to be a relationship between work hours and loan amount? Explain your answer.

· Explain the meaning of the coefficient of determination as it applies specifically to this problem.

· Explain the meaning of the slope in the regression equation as it applies specifically to this problem. Is this the relationship you expected? Explain. If it isn’t what you expected, explain why it might have occurred.

· Does a linear model appear to be appropriate for this comparison? Explain.

9. For students with credit card debt, does there appear to be a difference in the mean amount of credit card debt based on gender of the student? Conduct an appropriate two-sample t-test. Be sure to state the null and alternate hypotheses, include the output from StatCrunch, and briefly answer the question.

NOTE: You will need to use the following in the Where blocks in StatCrunch for this test as shown to the right: Gender=Male and “CC Debt”>0, Gender=Female and “CC Debt”>0.

10. Is there evidence of a relationship between class and whether or not students work? Conduct a chi-square test of independence. State the null and alternate hypotheses, include StatCrunch output, and explain the results of your test.

To set up this problem, you will need to use the Bin(Work) column you created in Problem 5. Open the StatCrunch U file and go to Stat>Tables>Contingency>With Data and complete the menu as shown to the right.

Dot Image
Tutorials for this Question
  1. Tutorial # 00384104 Posted By: lola1 Posted on: 09/18/2016 02:34 AM
    Puchased By: 3
    Tutorial Preview
    The solution of Module 6 - Assignment: Quantitative Data Analysis Assignment...
    Attachments
    Module_6_Assignment.docx (88.85 KB)
    Recent Feedback
    Rated By Feedback Comments Rated On
    T...e1 Rating Instant customer support services 10/19/2016

Great! We have found the solution of this question!

Whatsapp Lisa