Bella Capelli Academy Domestic Activities Statistical Analysis Reports need 3 statistics assignment completed as attached……………………………. | Course Hero
Bella Capelli Academy Domestic Activities Statistical Analysis Reports need 3 statistics assignment completed as attached……………………………………………………………… Argue – 1st Year
Student
3.67
4.50
4.83
5.75
3.94
7.08
7.17
4.92
7.29
4.69
6.42
5.52
1.48
4.12
4.02
4.15
5.09
5.46
6.50
4.45
8.00
8.10
5.56
8.24
5.30
7.25
6.24
1.67
4.66
4.54
7.08
Argue – 2nd Year
Student
4.77
5.85
6.28
7.48
5.12
9.20
9.32
6.40
9.48
6.10
8.35
7.18
1.92
5.36
5.23
5.39
6.61
7.10
8.45
5.79
10.40
10.53
7.23
10.71
6.89
9.43
8.11
2.17
6.05
5.91
9.20
Argue – 3rd Year
Student
3.59
4.42
4.75
5.67
3.86
7.00
7.09
4.84
7.21
4.61
6.34
5.44
1.40
4.04
3.94
4.07
5.00
5.38
6.42
4.37
7.92
8.02
5.48
8.16
5.22
7.17
6.16
1.59
4.57
4.46
7.00
Belch – 1st Year Belch – 2nd Year
Student
Student
13.99
12.80
13.10
11.91
13.26
12.06
12.58
11.39
7.74
6.55
14.67
13.48
15.07
13.88
11.98
10.79
12.42
11.23
7.66
6.47
12.50
11.31
7.51
6.32
4.24
3.05
9.68
8.48
9.97
8.77
15.81
14.62
14.80
13.61
14.98
13.79
14.21
13.02
8.75
7.55
16.57
15.38
17.03
15.84
13.54
12.34
14.04
12.85
8.66
7.47
14.13
12.93
8.48
7.29
4.79
3.60
10.93
9.74
11.26
10.07
14.67
13.48
Belch – 3rd Year Belch – 4th Year
Student
Student
11.28
14.00
10.39
13.11
10.54
13.27
9.86
12.59
5.02
7.75
11.95
14.68
12.36
15.09
9.26
11.99
9.71
12.44
4.95
7.67
9.79
12.51
4.79
7.52
1.52
4.24
6.96
9.69
7.25
9.98
13.09
15.83
12.09
14.82
12.26
14.99
11.50
14.23
6.03
8.76
13.86
16.59
14.32
17.05
10.82
13.55
11.32
14.05
5.94
8.67
11.41
14.14
5.77
8.49
2.07
4.79
8.22
10.94
8.55
11.27
11.95
14.68
Cry – 1st Year
Student
6.79
5.96
5.92
5.79
3.79
5.87
7.63
5.29
1.85
5.56
5.52
4.21
1.00
5.12
4.69
7.67
6.73
6.69
6.54
4.28
6.63
8.62
5.98
2.09
6.28
6.24
4.76
1.13
5.79
5.30
5.87
Cry – 2nd Year
Student
3.97
3.48
3.46
3.38
2.21
3.43
4.46
3.09
1.08
3.25
3.22
2.46
0.58
2.99
2.74
4.48
3.93
3.91
3.82
2.50
3.87
5.04
3.49
1.22
3.67
3.64
2.78
0.66
3.38
3.10
3.43
Cry – 3rd Year
Student
13.35
11.71
11.64
11.38
7.45
11.54
15.00
10.40
3.64
10.93
10.85
8.27
1.97
10.06
9.22
15.08
13.24
13.15
12.86
8.42
13.04
16.95
11.75
4.11
12.35
12.26
9.35
2.22
11.37
10.42
11.54
Cry – 4th Year
Student
0.86
2.07
3.10
1.73
-0.28
1.89
1.87
1.10
-0.77
1.63
1.38
3.12
2.58
2.55
2.46
1.14
2.52
3.68
2.13
-0.14
2.31
2.29
1.42
-0.70
2.02
1.74
2.07
Cry – 5th Year
Student
8.85
13.71
17.82
12.35
4.32
12.98
12.89
9.83
2.34
11.96
10.95
17.92
15.73
15.62
15.28
10.00
15.49
20.14
13.96
4.88
14.67
14.57
11.11
2.64
13.51
12.38
13.71
Duration of Listed Behaviors Among Students in an Introd
Eat
4.77
1.21
3.52
0.56
0.87
7.62
7.27
4.17
1.52
1.33
3.90
6.65
1.06
1.81
0.96
5.39
1.37
3.98
0.63
0.98
8.61
8.22
4.71
1.72
1.50
4.41
7.51
1.20
2.05
1.08
7.62
Fight
7.79
5.42
7.48
7.33
5.94
8.38
7.96
7.54
7.63
7.10
7.42
7.23
4.75
6.60
6.96
8.80
6.12
8.45
8.28
6.71
9.47
8.99
8.52
8.62
8.02
8.38
8.17
5.37
7.46
7.86
8.38
Jump
7.21
4.58
5.88
6.71
1.58
7.29
7.52
5.46
6.69
5.25
6.88
5.35
2.27
4.42
1.88
8.15
5.18
6.64
7.58
1.79
8.24
8.50
6.17
7.56
5.93
7.77
6.05
2.57
4.99
2.12
7.29
Kiss
7.71
0.30
5.28
4.56
1.44
7.40
8.85
4.75
3.12
4.28
4.70
6.92
0.54
2.75
4.38
8.71
0.34
5.97
5.15
1.63
8.36
10.00
5.37
3.52
4.84
5.32
7.81
0.61
3.11
4.95
7.40
Laugh
2.77
1.00
1.90
1.87
0.90
6.40
3.12
1.60
1.06
0.77
2.23
3.10
0.83
1.25
1.10
3.13
1.13
2.15
2.11
1.02
7.23
3.53
1.81
1.20
0.87
2.52
3.50
0.94
1.41
1.24
6.40
rs Among Students in an Introduction to Basket Weaving Class (BW 101)
Mumble
5.38
5.88
3.83
6.46
3.60
5.48
7.69
4.04
4.87
2.79
3.88
3.96
1.33
3.50
3.77
6.08
6.64
4.33
7.30
4.07
6.19
8.69
4.57
5.50
3.15
4.38
4.47
1.50
3.96
4.26
5.48
Read
1.73
6.12
1.83
5.04
1.23
5.42
6.52
4.19
7.27
4.29
4.52
4.25
0.42
0.44
5.31
1.95
6.92
2.07
5.70
1.39
6.12
7.37
4.73
8.22
4.85
5.11
4.80
0.47
0.50
6.00
5.42
Run
6.48
4.00
7.56
6.44
1.06
7.62
7.06
3.42
6.54
7.04
7.37
6.17
2.85
4.60
4.88
7.32
4.52
8.54
7.28
1.20
8.61
7.98
3.86
7.39
7.96
8.33
6.97
3.22
5.20
5.51
7.62
Shout
7.06
5.21
6.00
7.04
2.08
7.67
7.35
4.12
6.58
4.87
7.27
5.48
2.56
5.40
1.06
7.98
5.89
6.78
7.96
2.35
8.67
8.31
4.66
7.44
5.50
8.22
6.19
2.89
6.10
1.20
7.67
Sleep
5.40
5.23
1.96
6.71
3.37
7.23
8.25
7.54
4.92
6.10
7.69
6.17
0.15
2.92
6.02
6.10
5.91
2.21
7.58
3.81
8.17
9.32
8.52
5.56
6.89
8.69
6.97
0.17
3.30
6.80
7.23
Talk
2.79
0.44
0.92
0.48
0.58
5.71
0.54
0.81
4.02
0.75
1.60
1.75
0.42
1.12
0.92
3.15
0.50
1.04
0.54
0.66
6.45
0.61
0.92
4.54
0.85
1.81
1.98
0.47
1.27
1.04
5.71
Write
0.83
5.38
4.13
6.42
2.00
6.15
4.15
5.62
6.27
3.62
5.96
5.54
0.71
1.27
4.44
0.94
6.08
4.67
7.25
2.26
6.95
4.69
6.35
7.09
4.09
6.73
6.26
0.80
1.44
5.02
6.15
Perform an ‘One-Way ANOVA….” and include the below:
1. First, state an appropriate null and alternative hypothesis
2. Perform descriptive statistics for all three years
3. Calculate the ANOVA comparing argue between 1st, 2nd, and 3rd year
students
4. Write 3-4 sentences answering the questions below (a-c). (see template
text in Power Point lecture):
a. Summarizing the ANOVA procedure
b. Summarizing the ANOVA results
c. State whether you accept or reject the null hypothesis
5. Create a single ‘means plot’ chart displaying the three group means with
lines connecting each mean
Perform an ‘One-Way ANOVA….” and include the below:
1. First, state an appropriate null and alternative hypothesis
2. Perform descriptive statistics for all four years
3. Calculate the ANOVA comparing belch in 1st, 2nd, 3rd, and 4th year
students
4. Write 3-4 sentences answering the questions below (a-c). (see template
text in Power Point lecture):
a. Summarizing the ANOVA procedure
b. Summarizing the ANOVA results
c. State whether you accept or reject the null hypothesis
5. Create a single ‘means plot’ chart displaying the three group means with
lines connecting each mean
Perform an ‘One-Way ANOVA….” and include the below:
1. First, state an appropriate null and alternative hypothesis
2. Perform descriptive statistics for all five years
3. Calculate the ANOVA comparing crying between 1st, 2nd, 3rd, 4th, and 5th
year students
4. Write 3-4 sentences answering the questions below (a-c). (see template
text in Power Point lecture):
a. Summarizing the ANOVA procedure
b. Summarizing the ANOVA results
c. State whether you accept or reject the null hypothesis
5. Create a single ‘means plot’ chart displaying the three group means with
lines connecting each mean
Sex
Female
Male
Male
Female
Female
Male
Female
Female
Female
Female
Female
Male
Female
Male
Female
Female
Female
Female
Female
Female
Male
Male
Male
Male
Female
Male
Male
Male
Male
Male
Female
Female
Female
Male
Female
Female
Male
Male
Female
Female
Male
Male
Male
Male
Beer Preference
Dark Beer
Amber Beer
Amber Beer
Amber Beer
Dark Beer
Amber Beer
Dark Beer
Dark Beer
Dark Beer
Dark Beer
Dark Beer
Amber Beer
Dark Beer
Amber Beer
Dark Beer
Dark Beer
Dark Beer
Amber Beer
Dark Beer
Amber Beer
Amber Beer
Amber Beer
Amber Beer
Amber Beer
Amber Beer
Amber Beer
Amber Beer
Amber Beer
Amber Beer
Amber Beer
Amber Beer
Dark Beer
Amber Beer
Amber Beer
Dark Beer
Amber Beer
Amber Beer
Amber Beer
Dark Beer
Dark Beer
Amber Beer
Dark Beer
Amber Beer
Dark Beer
Eye Color Hand Preference
Blue
Blue
Brown
Blue
Blue
Blue
Brown
Brown
Blue
Blue
Blue
Blue
Blue
Blue
Blue
Blue
Blue
Blue
Blue
Blue
Blue
Blue
Blue
Brown
Blue
Blue
Blue
Blue
Blue
Blue
Brown
Brown
Blue
Blue
Blue
Blue
Blue
Blue
Blue
Blue
Blue
Blue
Blue
Blue
Left
Left
Left
Right
Right
Right
Right
Left
Right
Left
Right
Left
Left
Left
Left
Left
Left
Left
Left
Right
Left
Left
Right
Right
Right
Right
Left
Left
Left
Left
Left
Left
Left
Left
Left
Left
Right
Left
Left
Right
Right
Left
Right
Right
Sex
F
F
F
M
F
F
M
F
M
F
F
M
F
F
F
M
F
F
F
F
F
F
F
M
F
M
F
M
F
F
F
F
M
F
M
F
F
F
F
F
M
M
F
F
Male
Female
Male
Male
Male
Female
Female
Male
Female
Female
Female
Male
Female
Female
Male
Female
Male
Male
Male
Female
Male
Female
Male
Female
Female
Male
Female
Male
Female
Female
Female
Male
Female
Male
Female
Male
Female
Male
Female
Male
Male
Female
Male
Male
Male
Female
Female
Amber Beer
Dark Beer
Dark Beer
Amber Beer
Amber Beer
Amber Beer
Amber Beer
Amber Beer
Amber Beer
Dark Beer
Dark Beer
Amber Beer
Dark Beer
Dark Beer
Dark Beer
Dark Beer
Dark Beer
Amber Beer
Amber Beer
Dark Beer
Amber Beer
Dark Beer
Amber Beer
Dark Beer
Dark Beer
Amber Beer
Amber Beer
Amber Beer
Dark Beer
Amber Beer
Amber Beer
Amber Beer
Amber Beer
Amber Beer
Dark Beer
Dark Beer
Dark Beer
Amber Beer
Amber Beer
Amber Beer
Amber Beer
Dark Beer
Amber Beer
Amber Beer
Amber Beer
Amber Beer
Amber Beer
Blue
Brown
Blue
Blue
Blue
Blue
Brown
Blue
Blue
Blue
Brown
Brown
Blue
Blue
Blue
Blue
Brown
Blue
Brown
Blue
Blue
Brown
Blue
Blue
Blue
Blue
Brown
Brown
Blue
Blue
Brown
Blue
Blue
Blue
Blue
Blue
Brown
Brown
Blue
Blue
Blue
Brown
Blue
Brown
Blue
Blue
Brown
Left
Left
Left
Left
Right
Left
Left
Left
Left
Left
Left
Left
Left
Right
Left
Left
Left
Left
Left
Left
Left
Left
Right
Left
Right
Right
Left
Right
Left
Right
Left
Left
Left
Right
Left
Left
Left
Left
Right
Right
Left
Left
Left
Right
Right
Left
Left
F
F
F
F
F
F
M
F
F
F
F
M
M
F
M
F
F
F
M
F
M
F
M
M
F
M
F
F
M
F
F
M
F
M
M
F
F
F
F
M
F
F
F
F
F
M
M
Female
Male
Female
Male
Male
Male
Male
Male
Female
Dark Beer
Amber Beer
Amber Beer
Dark Beer
Dark Beer
Amber Beer
Dark Beer
Amber Beer
Dark Beer
Blue
Blue
Blue
Blue
Blue
Blue
Brown
Brown
Blue
Right
Left
Right
Left
Right
Left
Right
Left
Left
M
F
F
F
F
F
F
M
F
Academic Level in
College
GR
GR
GR
GR
UG
UG
GR
GR
GR
GR
GR
GR
GR
GR
GR
UG
UG
GR
GR
GR
GR
UG
GR
UG
UG
GR
UG
UG
GR
UG
UG
GR
GR
GR
GR
GR
GR
GR
GR
GR
GR
GR
UG
UG
INSTRUCTIONS:
1. For each pair of data columns, write a null and alternative hypothesis (one to a
worksheet)
2. Calculate the observed frequency (e.g., total number of ‘Female – Amber Beer’
responses, total number of ‘Male – Dark Beer’ responses, etc.)*Pivot Table*
3. Enter the observed frequencies in the green cells on each worksheet
4. Under you null and alternative hypotheses, write in sentence form:
a. What test you performed
b. What the IV and DV are
c. Whether you accept or reject the null hypothesis
d. Write out the chi-square statistics
Each pair should be on its own worksheet. The worksheet should have the hypothes
pivot table, the response from #4. It should have a descriptive name (ie. Sex/BeerPr
UG
GR
UG
UG
GR
GR
GR
GR
GR
UG
UG
UG
UG
UG
UG
UG
UG
GR
UG
UG
GR
UG
UG
GR
UG
UG
GR
GR
GR
UG
GR
GR
UG
GR
GR
GR
GR
UG
GR
UG
GR
GR
GR
GR
UG
GR
GR
GR
UG
GR
GR
GR
GR
GR
GR
GR
tive hypothesis (one to a
f ‘Female – Amber Beer’
etc.)*Pivot Table*
ach worksheet
ntence form:
et should have the hypotheses,
iptive name (ie. Sex/BeerPref).
5.
Chi-Square 2 x 2 Design
Observed Values
Enter values in grey cells below:
Expected Values
Variable 2
X
Y
Variable 1
Row Totals
0
0
A
B
Column Totals
0
0
#DIV/0!
#DIV/0!
0
Grand Total
Scroll Down for Instructions
Column Proportions
X
Y
#DIV/0! #DIV/0!
#DIV/0! #DIV/0!
A
B
1
0.9
0.9
0.8
0.8
0.7
0.7
0.6
0.6
0.5
A
0.5
0.4
B
0.4
0.3
0.3
0.2
0.2
0.1
0.1
0
X
Instructions:
Y
?
1. Enter your observed frequencies in the grey cells.
Important: Do not alter the numeric values in the any of the other cells.
2. If you wish, you can change the names of the variables (Variables 1 and 2) to something more descr
3. You can also change the names of the levels of each variable (A, B and X, Y).
Changing the names of the levels on the Observed Values table will automatically update the labels
4. The graph to the left is the proportion of observed frequency for the columns.
5. The graph to the right is the proportion of observed frequency for the rows.
Feel free to pick whichever graph you feel is more appropriate for your hypothesis, or you can igno
2 x 2 Design
Expected Values
Test Results:
? 2=
df =
p=
#DIV/0!
#DIV/0!
ONLY Enter
Numbers in the
Green Cells!
Effect Size
d=
r=
1
Row Proportions
X
Y
#DIV/0! #DIV/0!
#DIV/0! #DIV/0!
A
B
1
0.9
0.8
0.7
0.6
0.5
X
0.4
Y
0.3
0.2
0.1
0
A
d 2) to something more descriptive.
utomatically update the labels for the graphs below.
B
ONLY Enter
Numbers in the
Green Cells!
Chi-Square 2 x 2 Design
Observed Values
Enter values in grey cells below:
Expected Values
Variable 2
X
Y
Variable 1
Row Totals
0
0
A
B
Column Totals
0
0
#DIV/0!
#DIV/0!
0
Grand Total
Scroll Down for Instructions
Column Proportions
X
Y
#DIV/0! #DIV/0!
#DIV/0! #DIV/0!
A
B
1
0.9
0.9
0.8
0.8
0.7
0.7
0.6
0.6
0.5
A
0.5
0.4
B
0.4
0.3
0.3
0.2
0.2
0.1
0.1
0
X
Instructions:
Y
?
1. Enter your observed frequencies in the grey cells.
Important: Do not alter the numeric values in the any of the other cells.
2. If you wish, you can change the names of the variables (Variables 1 and 2) to something more descr
3. You can also change the names of the levels of each variable (A, B and X, Y).
Changing the names of the levels on the Observed Values table will automatically update the labels
4. The graph to the left is the proportion of observed frequency for the columns.
5. The graph to the right is the proportion of observed frequency for the rows.
Feel free to pick whichever graph you feel is more appropriate for your hypothesis, or you can igno
2 x 2 Design
Expected Values
Test Results:
? 2=
df =
p=
#DIV/0!
#DIV/0!
ONLY Enter
Numbers in the
Green Cells!
Effect Size
d=
r=
1
Row Proportions
X
Y
#DIV/0! #DIV/0!
#DIV/0! #DIV/0!
A
B
1
0.9
0.8
0.7
0.6
0.5
X
0.4
Y
0.3
0.2
0.1
0
A
d 2) to something more descriptive.
utomatically update the labels for the graphs below.
B
ONLY Enter
Numbers in the
Green Cells!
Chi-Square 2 x 2 Design
Observed Values
Enter values in grey cells below:
Expected Values
Variable 2
X
Y
Variable 1
Row Totals
0
0
A
B
Column Totals
0
0
#DIV/0!
#DIV/0!
0
Grand Total
Scroll Down for Instructions
Column Proportions
X
Y
#DIV/0! #DIV/0!
#DIV/0! #DIV/0!
A
B
1
0.9
0.9
0.8
0.8
0.7
0.7
0.6
0.6
0.5
A
0.5
0.4
B
0.4
0.3
0.3
0.2
0.2
0.1
0.1
0
X
Instructions:
Y
?
1. Enter your observed frequencies in the grey cells.
Important: Do not alter the numeric values in the any of the other cells.
2. If you wish, you can change the names of the variables (Variables 1 and 2) to something more descr
3. You can also change the names of the levels of each variable (A, B and X, Y).
Changing the names of the levels on the Observed Values table will automatically update the labels
4. The graph to the left is the proportion of observed frequency for the columns.
5. The graph to the right is the proportion of observed frequency for the rows.
Feel free to pick whichever graph you feel is more appropriate for your hypothesis, or you can igno
2 x 2 Design
Expected Values
Test Results:
? 2=
df =
p=
#DIV/0!
#DIV/0!
ONLY Enter
Numbers in the
Green Cells!
Effect Size
d=
r=
1
Row Proportions
X
Y
#DIV/0! #DIV/0!
#DIV/0! #DIV/0!
A
B
1
0.9
0.8
0.7
0.6
0.5
X
0.4
Y
0.3
0.2
0.1
0
A
d 2) to something more descriptive.
utomatically update the labels for the graphs below.
B
ONLY Enter
Numbers in the
Green Cells!
1. For each set of ‘paired variables’ (e.g., Age – Fuzzy Dice & Age – No Fuzzy Dice), complete the following:
a. t -test (see ‘Instructions – t -test’ worksheet in this document)
b. Descriptive Statistics
c. Graph of means plot (see ‘Instructions – Means Plot’ document in the Reporting Results folder on BB)
d. Written explanation (see ‘Instructions – t -test’ worksheet & ‘t -test – Decodes Excel Output’ on BB)
e. Triple check all your work and upload your Word document to BB
STEP 1. State your hypotheses for the t -test
(write them in your merged cells below the output)
STEP 3. Select 1 group’s column for ‘Variable 1 Range:’ and the other
associated group for ‘Variable 2 Range:’, & Select ‘Labels’
STEP 2. Choose ‘t-Test: Two-Sample Assuming Equal Variances’ from the ‘Data Analysis’ add-in
This sheet
will print on
one page
STEP 4. Interpret t -test output & translate into sentences
t-Test: Two-Sample Assuming Equal Variances
Example write up of t -test analysis
Mean
Variance
Observations
Pooled Variance
Hypothesized Mean Difference
df
t Stat
P(T
Purchase answer to see full
attachment
