0 Comments

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.

Order Solution Now

Categories: