I need help with a critical thinking assignment for my statistic class.

Fall 2020

Critical Thinking Assignment: Data Analysis Part 1 (50 points)

DUE DATE: OCTOBER 20

INSTRUCTIONS:

Data analysis is the process of applying statistical techniques to illustrate, evaluate, and to derive meaning from data. In this critical thinking assignment, you are going to perform data analysis using the data obtained from the student survey.

You are going to compare two groups of students. The first group will comprise students who have a dependent child. The second group will comprise those who do not have a dependent child. You will compare both groups on selected measures to determine if significant differences exist between both groups.

The first step is to select a sample of students from each group. Follow the instructions below to select your samples.

1. Go into D2L and open the folder named STUDENT SURVEY, then open the file named STUDENT SURVEY DATA FILE.

2. Using the random number generator http://stattrek.com/Tables/Random.aspx . Select a random sample of 50 students who have a dependent child and a random sample of 50 students who do not have a dependent child. The student survey data file is already sorted by the variable “dependent child”. Students who do not have a dependent child are listed from # 1 through #647. Students who have a dependent child are listed from #648 through #862.

3. For each student selected in your samples, list the values for each of the following variables:

a. Student ID

b. Age

c. GPA

d. Total Credit Hours Completed

e. Hours worked per week

f. How anxious are you about taking this course?

g. How difficult do you think this course is going to be?

h. Hours spent on schoolwork at home

Your final data file will look like this:

STU ID	Age	GPA	Total Credit Hours Completed	Hours Worked per Week	How anxious are you about taking this course	How difficult do you think this course is going to be	Hours spent on schoolwork at home
33	22	2.80	36	40	7	5	5

4. Using the variable “Age”, construct a frequency distribution to summarize the ages of students who do not have a dependent child. Construct another frequency distribution to summarize the ages of students who have a dependent child. Use 5 classes to construct your frequency distributions. For each frequency distribution, show your calculations for the class width and then list the:

a. Lower limits and upper limits

b. Frequencies for each class

c. Class boundaries

d. Class mid-points

e. Relative frequencies

f. Cumulative frequencies

5. Using the variable Total Credit Hours, construct a frequency distributions to summarize the total credit hours completed by students who do not have a dependent child. Construct another frequency distribution to summarize the ages of students who have a dependent child. Use 5 classes to construct your frequency distribution. For each frequency distribution, show your calculations for the class width and then list the:

a. Lower limits and upper limits

b. Class boundaries

c. Class mid-points

d. Relative frequencies

e. Cumulative frequencies

6. Using the variable Hours spent on homework, construct a frequency distribution to summarize the hours spent on homework by students who do not have a dependent child. Construct another frequency distribution to summarize the hours spent on homework of students who have a dependent child. Use 5 classes to construct your frequency distribution. For each frequency distribution, show your calculations for the class width and then list the:

a. Lower limits and upper limits

b. Class boundaries

c. Class mid-points

d. Relative frequencies

e. Cumulative frequencies

7. Using Excel create six histograms, properly labeled, depicting the data from the frequency distributions in # 4, #5, and #6 above.

8. Describe the shape of the data for each of the six histograms. Is it normally distributed? Positively skewed, negatively skewed, uniform? Or maybe the shape cannot be clearly determined from your sample data, in which case you would indicate “shape cannot be determined”.

9. Make at least two observations about each of the frequency distributions or histograms you have constructed?

10. Upload your data file, your frequency distributions, and your histograms in D2L folder entitled critical thinking assignment..