Create a Statistics Notebook for Pearson’s r, Simple Regression, One-Way Analysis of Variance, and Chi-Square (include independence and goodness of fit).

For each test listed below, please give the definition, when to use it, data set, data conditions, statistical procedures, annotated output and a standardized write-up. A detailed example is attached and you must use the data from the excel spreadsheet. Screenshots from excel are needed for the statistical procedures and annotated output parts. A template is given for the standardized write-up. The numbers would need to entered into the narrative. Pearson’s rSimple RegressionOne-Way Analysis of VarianceChi-Square (include independence and goodness of fit)Pages 1-4 of the attached document are the directions and a detailed example. You have to use the data from the excel document that is also attached.
studypool_statistical_notebook.docx

studypool_2017_ccrpi_achievement_indicator_data.xlsx

Don't use plagiarized sources. Get Your Custom Essay on
Create a Statistics Notebook for Pearson’s r, Simple Regression, One-Way Analysis of Variance, and Chi-Square (include independence and goodness of fit).
Just from $13/Page
Order Essay

Unformatted Attachment Preview

Statistical Notebook: YOUR NAME
Topics to Include
Part
•
•
•
•
Template
Definition:
When to Use it:
Data Set:
Data Conditions:
Statistical Procedures:
Annotated Output:
Standardized Write-up
Pearson’s r
Simple Regression
One-Way Analysis of Variance
Chi-Square (include independence
and goodness of fit)
1
Statistical Notebook: YOUR NAME
Mean
Definition:This is a definition of the term. You need to make sure the definition 1) is accurate
and 2) makes sense to you. I have provided 3 different ways of defining the term. You need to
select the way to define the term which is most meaningful to you (You may want to define it
multiple ways).
The mean is the arithmetic average of all values in a data distribution. Meaning, it is the average
of all of the numbers in the data set.
?¯ =
???? (???????) =
??
?
??? ?? ??? ?? ?h? ?????? ?? ?h? ???? ???
?????? (?????) ?? ?????? ?? ?h? ???? ???
When to Use it:This information helps me remember when it is appropriate to use this statistic.
It is a descriptive statistic which is provided when reporting general information about a data set.
Data Set:This is information about the data set that was used. For the purposes of this course,
publically available data will be provided. However, if you desire to use your own data set that
is fine too.
This example uses 2014 Content Mastery by Subgroup Amended _ECOT_CRCT file which
includes all schools across the state of Georgia.
Data Conditions:This will be the variables from your data set above which use used for this
topic. You may have additional notes about the data that are meaningful to you and should be
included.
The variables used for this exercise include all System IDs, System Names, School Names which
gave the CRCT. School ID was filtered to remove “ALL” because the ‘ALL’ school ID is the
system ID. Meets and Exceeds was filtered to remove blanks. The Assessment Type used is
CRCT and the Assessment Subject area is English Language Arts (ELA). Additionally, the
Reporting Category was Hispanic.
Statistical Procedures:These are the steps you took. They are instructions in the event you need
to find the mean of another data set. Throughout the course you may choose to use Excel, SPSS,
or R. You may want to run this using two different programs so you have the notes for yourself. I
have provided 3 examples for recoding the directions. You should find the best way to record
your steps in a way which is clear to both me and yourself.
Example:
Excel Directions
1) Copy data into a new Excel Worksheet
2) Formulas Tab
2
Statistical Notebook: YOUR NAME
3) More Functions ? Statistical ? Average
4) Highlight the Cells
5) Average Reported in Cell
3
Statistical Notebook: YOUR NAME
Annotated Output: This is the output which resulted from the previous step. You will want to
copy and paste the table or use a screenshot.
Average ELA score for Hispanic Students taking the CRCT in 2014 for schools which had a
student N count greater than or equal to 15.
Standardized Write-up: This is your write up of the outcome from the analysis.
4
Statistical Notebook: YOUR NAME
Pearson’s r
Definition:
When to Use it:
Data Set:
Data Conditions:
Statistical Procedures:
Annotated Output:
Standardized Write-up: A Pearson’ r was computed to assess the relationship between [Variable
1] and [Variable 2] for [x number of data points (e.g. 187 countries)]. The results of the
correlational analysis show that the correlation [was/ was not] statistically significant
(p<[.05/.01]) and was equal to [value]. The results suggest that there [is/is not] a strong relationship between [Variable 1] and [Variable 2]. Simple Regression Definition: When to Use it: Data Set: Data Conditions: Statistical Procedures: Annotated Output: Standardized Write-up: Option 1: A linear regression analysis was conducted to evaluate the prediction of [dependent variable] for [independent variable ]. The scatterplot for the two variables indicates a [linear relationship] and as [dependent variable] increases [independent variable] increases as well. A significant regression equation was found (F([regression df], [residual df]) = [F Value], p,[Significance 2 value (e.g. .05, .000]), with an R of [R Square value]. Participants’ predicted [dependent variable] is equal to [ß Constant]+[ß height] [Independent variable measure] [dependent variable measure (e.g. score)] when [independent variable] is measured. Participants’ [dependent variable] [increased/decreased] [ß height] in relation to [independent variable]. Option 2: A linear regression analysis was conducted to evaluate the prediction of [depended variable] for [independent variable]. The scatterplot for the two variables indicates a linear relationship and as [independent variable] increases [dependent variable] increases as well. The regression equation for predicting the [dependent variable] is: [dependent variable]= [ß height][independent variable] + [ß Constant] The 95% confidence interval for the slope, [lower bound] to [upper bound] [does not/does] contain the value of zero, and therefore [independent variable] is significantly related to [dependent variable]. As hypothesized, higher [independent variable] tend to have a higher [dependent variable]. Accuracy in predicting the [dependent variable] was [weak/moderate/strong]. The correlation between [independent variable] and [dependent variable] was [score]. Approximately [x%] of the variance of the [dependent variable] was accounted for by its linear relationships with [independent variable]. 5 Statistical Notebook: YOUR NAME One-Way Analysis of Variance Definition: When to Use it: Data Set: Data Conditions: Statistical Procedures: Annotated Output: Standardized Write-up: A one-way analysis of variance was conducted to evaluate the relationship between [independent variable] and the [dependent variable]. The independent variable, [independent variable], included [number] levels: [identify the levels]. The dependent variable was [dependent variable] [measure (e.g. score, minutes)]. The ANOVA was [significant/ not significant], F([between group df],[within groups]) = [f-value], p = [significance level (e.g. .05,.001)]. The relationship 2 between the [independent variable] and the [dependent variable] was assessed by ? and indicated that the hold type factor accounted for [X]% of the variance of the dependent variable, [dependent variable]. Chi-Square (include independence and goodness of fit) Definition: When to Use it: Data Set: Data Conditions: Statistical Procedures: Annotated Output: Standardized Write-up: Chi-square test of independence – (Examines if there is a relationship between two variables) A one-sample chi-square test was conducted to assess the relationship between [variable 1] and [variable 2]. The results of the test [were/were not] significant, ?2 ([??], ? = [n value]) = [value], p < [.05, .000]). Chi-square test of goodness of fit – (Uses proportions from sample to examine hypothesis about population proportions) A chi-square test of goodness-of-fit was performed to determine [identify what it is you are trying to determine]. [Outcome] [was/ was not] equally distributed in the population, ?2 ([??], ? = [? ?????]) = [value], p < [.05, .000]) . The proportion of [Variable] were identified as [Variable 1] ([X%]) was [greater/less] than [variable 2] ([Y%]). The results suggest that [interpret your results]. Final interpretation in your words: Example: Taken together, these results suggest that callers hold longer when listening to classical music than when listening to muzak. However, they do not differ significantly in wait time when comparing advertisement to classical hold times or muzak to advertisement hold times. 6 System ID 601 601 601 602 602 603 603 606 606 607 607 607 607 607 607 607 607 608 608 608 608 608 608 608 608 609 609 610 610 611 611 611 614 616 616 616 622 622 622 System Name School ID Appling County 177 Appling County 277 Appling County 1050 Atkinson County 187 Atkinson County 190 Bacon County 102 Bacon County 3050 Banks County 107 Banks County 205 Barrow County 105 Barrow County 189 Barrow County 193 Barrow County 205 Barrow County 298 Barrow County 1050 Barrow County 4050 Barrow County 5050 Bartow County 104 Bartow County 115 Bartow County 175 Bartow County 186 Bartow County 196 Bartow County 296 Bartow County 377 Bartow County 2052 Ben Hill County 111 Ben Hill County 196 Berrien County 195 Berrien County 5050 Bibb County 1067 Bibb County 1307 Bibb County 1309 Brooks County 193 Bulloch County 199 Bulloch County 2050 Bulloch County 5054 Carroll County 100 Carroll County 176 Carroll County 5050 Percent of English Learners with positive movement from one Performance Band to a higher Performance Band as measured by the ACCESS for ELLs School Name Appling County Elementary School 74.413 Appling County Primary School62.106 Altamaha Elementary School 53.826 Willacoochee Elementary School 92.272 Pearson Elementary School 64.491 Bacon County Primary School 86.505 Bacon County Elementary School 76.894 Banks County Elementary School 52.428 Banks County Primary School 93.37 County Line Elementary School63.904 Kennedy Elementary School 63.881 Bramlett Elementary School 86.505 Bethlehem Elementary School 79.851 Yargo Elementary School 86.047 Auburn Elementary School 73.992 Holsenbeck Elementary School 83.437 Statham Elementary School 79.601 Clear Creek Elementary School 84.987 Cloverleaf Elementary 71.401 White Elementary School 84.287 Mission Road Elementary School 87.499 Allatoona Elementary School 81.416 Kingston Elementary School 83.437 Hamilton Crossing Elementary School 67.614 Emerson Elementary School 73.398 Ben Hill Elementary School 72.088 Ben Hill County Primary School65.909 Berrien Elementary School 53.826 Berrien Primary School 100 Porter Elementary School 44.362 Southfield Elementary School 52.089 Veterans Elementary School 75.692 Quitman Elementary School 51.903 Langston Chapel Elementary School 77.933 Julia P. Bryant Elementary School 79.296 Sallie Zetterower Elementary School 84.582 Sharp Creek Elementary School65.193 Mount Zion Elementary School76.894 Central Elementary School 74.413 Weighted percent of students scoring at Developing Learner or above on the Georgia Milestones English Language Arts EOG (required participation rate >=
95%)
51.529
57.692
58.735
67.647
61.204
56.369
53.593
67.718
62.286
69.459
73.569
76.54
71.484
74.029
55.347
70.804
65.784
59.363
56.707
65.751
65.708
53.514
52.165
59.464
65.104
54.223
54.688
70.524
74.51
49.519
22.409
29.83
42.679
39.494
59.467
60.172
58.949
70.124
71.166
622
625
625
625
625
625
625
625
625
625
627
628
628
628
628
628
628
628
628
628
628
628
628
628
628
628
628
629
629
629
629
629
629
629
629
629
629
629
631
631
631
631
631
631
631
631
631
Carroll County 5052
Chatham County 116
Chatham County 197
Chatham County 211
Chatham County 298
Chatham County 300
Chatham County 511
Chatham County 2056
Chatham County 4058
Chatham County 4068
Chattooga County 106
Cherokee County 101
Cherokee County 104
Cherokee County 105
Cherokee County 108
Cherokee County 116
Cherokee County 182
Cherokee County 189
Cherokee County 190
Cherokee County 199
Cherokee County 203
Cherokee County 309
Cherokee County 313
Cherokee County 397
Cherokee County 409
Cherokee County 509
Cherokee County2054
Clarke County
105
Clarke County
112
Clarke County
178
Clarke County
191
Clarke County
205
Clarke County
391
Clarke County 1062
Clarke County 2056
Clarke County 2062
Clarke County 3058
Clarke County 4060
Clayton County 103
Clayton County 105
Clayton County 109
Clayton County 116
Clayton County 173
Clayton County 175
Clayton County 176
Clayton County 181
Clayton County 199
Sand Hill Elementary School 71.401
Pulaski Elementary SChool
100
Garden City Elementary School79.347
Godley Station School
98.461
Marshpoint Elementary School61.514
Southwest Elementary School
100
Shuman Elementary School
96.116
Gould Elementary School
74.632
Hesse School
68.422
Port Wentworth Elementary School
100
Leroy Massey Elementary School
91.311
Carmel Elementary School
72.847
Woodstock Elementary School 70.403
William G. Hasty, Sr. Elementary
75.795
School
Avery Elementary School
60.706
Indian Knoll Elementary
78.815
Johnston Elementary School 85.892
Boston Elementary School
62.614
Mountain Road Elementary School
93.714
Holly Springs Elementary School77.855
Liberty Elementary School
86.505
Little River Elem.
75.415
Clark Creek Elementary School 81.582
Arnold Mill Elementary School 81.582
Canton Elementary
69.789
J. Knox Elementary
70.692
Oak Grove Elementary School 62.223
Alps Road Elementary School 74.632
Judia Jackson Harris Elementary71.879
Timothy Elementary School
81.05
Cleveland Road Elementary School
70.208
Gaines Elementary School
60.416
Whit Davis Road Elementary School
61.062
Whitehead Road Elementary School
69.007
Barnett Shoals Elementary School
86.505
Winterville Elementary School 77.788
Fowler Drive Elementary School48.281
Oglethorpe Avenue Elementary80.097
School
Callaway Elementary School 72.681
Thurgood Marshall Elementary 82.069
School
Mount Zion Primary
80.555
Eddie White Academy
75.221
Kilpatrick Elementary School 75.304
Brown Elementary School
85.133
Mount Zion Elementary School81.416
Pointe South Elementary School79.851
Hawthorne Elementary School 81.953
73.229
52.09
43.313
66.899
70.588
47.385
25.068
45.881
65.347
46.569
38.958
79.806
63.83
35.309
79.159
78.519
70.748
68.495
82.579
62.179
80.694
76.414
67.518
72.384
43.7
78.729
55.556
30.903
38.776
76.844
44.366
31.463
66.848
63.05
54.329
36.813
44.472
46.862
49.259
46.209
41.176
44.075
40.56
50.614
46.751
42.332
51.498
631
631
631
631
631
631
631
631
631
631
631
631
631
631
631
631
631
631
631
631
631
631
631
631
631
631
631
633
633
633
633
633
633
633
633
633
633
633
633
633
633
633
633
633
633
633
633
Clayton County
Clayton County
Clayton County
Clayton County
Clayton County
Clayton County
Clayton County
Clayton County
Clayton County
Clayton County
Clayton County
Clayton County
Clayton County
Clayton County
Clayton County
Clayton County
Clayton County
Clayton County
Clayton County
Clayton County
Clayton County
Clayton County
Clayton County
Clayton County
Clayton County
Clayton County
Clayton County
Cobb County
Cobb County
Cobb County
Cobb County
Cobb County
Cobb County
Cobb County
Cobb County
Cobb County
Cobb County
Cobb County
Cobb County
Cobb County
Cobb County
Cobb County
Cobb County
Cobb County
Cobb County
Cobb County
Cobb County
200
203
204
205
276
295
304
305
307
1050
1052
1058
1060
1062
1550
2058
2060
2062
2554
3054
4050
4056
4060
5052
5054
5056
5060
102
104
107
109
110
114
117
118
173
187
189
190
191
194
198
199
204
207
214
273
Roberta T. Smith Elementary School
69.52
Harper Elementary School
72.423
Martin Luther King, Jr. Elementary
79.851
School
Kemp Primary
64.078
Oliver Elementary School
91.476
Lake Ridge Elementary School 63.251
James Jackson Elementary School
89.709
Kemp Elem School
96.886
Unidos Dual Language School 75.663
Anderson Elementary School 85.835
East Clayton Elementary School 100
Lee Street Elementary School 70.824
Northcutt Elementary School 55.81
Tara Elementary School
100
Arnold Elementary School
76.894
Morrow Elementary School 74.563
Riverdale Elementary School
100
West Clayton Elementary School
74.632
Fountain Elementary School
75.05
Haynie Elementary School
74.971
Church Street Elementary School
81.582
Lake City Elementary School 78.789
Suder Elementary School
78.134
Edmonds Elementary School 63.668
Huie Elementary School
80.435
William M. McGarrah Elementary
84.334
School
Swint Elementary School
99.51
Riverside Intermediate School 55.845
Bullard Elementary School
69.903
McCall Primary School
81.05
Pickett’s Mill Elementary
90.266
International Academy of Smyrna
79.851
East Side Elementary School
100
Clarkdale Elementary School 70.978
Mableton Elementary School 60.934
Birney Elementary School
76.894
Keheley Elementary School
55.163
Baker Elementary School
95.156
Dowell Elementary School
66.408
Varner Elementary School
97.129
Hayes Elementary School
86.791
Chalker Elementary School
89.709
Nickajack Elementary School 73.398
Pitner Elementary School
82.661
Austell Elementary School
74.87
Smyrna Elementary School
72.356
Kincaid Elementary School
93.37
46.588
49.872
39.362
59.337
47.068
46.309
57.411
52.83
46.934
39.932
51.971
34.859
37.546
38.144
66.955
56.098
40.065
39.431
42.57
48.921
45.806
52.128
48.964
35.333
36.61
54.082
53.523
42.233
85.731
59.091
84.576
62.535
104.766
58.399
45.122
48.25
91.667
80.682
67.3
72.452
68.02
77.151
69.728
74.665
69.433
59.07
87.607
633
633
633
633
633
633
633
633
633
633
633
633
633
633
633
633
633
633
633
633
633
633
633
633
633
633
633
633
633
633
633
633
633
633
633
633
633
633
634
634
634
634
634
634
635
635
635
Cobb County
Cobb County
Cobb County
Cobb County
Cobb County
Cobb County
Cobb County
Cobb County
Cobb County
Cobb County
Cobb County
Cobb County
Cobb County
Cobb County
Cobb County
Cobb County
Cobb County
Cobb County
Cobb County
Cobb County
Cobb County
Cobb County
Cobb County
Cobb County
Cobb County
Cobb County
Cobb County
Cobb County
Cobb County
Cobb County
Cobb County
Cobb County
Cobb County
Cobb County
Cobb County
Cobb County
Cobb County
Cobb County
Coffee County
Coffee County
Coffee County
Coffee County
Coffee County
Coffee County
Colquitt County
Colquitt County
Colquitt County
278
287
288
289
297
298
302
304
307
375
391
397
398
399
402
404
478
489
504
592
1052
1066
1067
2050
2062
3054
3058
3060
3062
3064
3067
3556
4068
4560
5050
5052
5067
5068
100
102
182
282
3052
5050
187
278
2052
Mount Bethel Elementary School 100
Lewis Elementary School
80.152
Mountain View Elementary School
86.505
Addison Elementary School
80.389
Frey Elementary School
79.851
Cheatham Hill Elementary School
87.759
Acworth Intermediate School 64.98
Kennesaw Charter School
74.148
Riverside Primary School
70.755
Murdock Elementary School 97.595
Nicholson Elementary School 75.221
Green Acres Elementary School65.747
Sanders Elementary School
74.49
Blackwell Elementary School 76.273
Hendricks Elementary School 71.167
Kennesaw Elementary School 76.894
Sope Creek Elementary School 88.202
Powder Springs Elementary School
65.193
Big Shanty Elementary School 75.105
Bryant Elementary School
73.916
Belmont Hills Elementary School
74.272
Norton Park Elementary School70.349
Powers Ferry Elementary School
84.739
Argyle Elementary School
66.179
King Springs Elementary School84.809
Clay Elementary School
57.67
Fair Oaks Elementary School 62.809
Harmony-Leland Elementary School
62.476
LaBelle Elementary School
64.684
Milford Elementary School
83.884
Russell Elementary School
72.552
Compton Elementary School
82.16
Teasley Elementary School
100
Hollydale Elementary School
68.23
Bells Ferry Elementary School 66.682
Brumby Elementary School
70.912
Sedalia Park Elementary School82.978
Eastvalley Elementary School 86.505
Indian Creek Elementary
71.698
Ambrose Elementary School 78.266
Satilla Elementary School
78.815
Eastside Elementary School 70.486
West Green Elementary School70.028
Westside Elementary School 80.236
Odom Elementary School
50.588
Norman Park Elementary School
73.992
Funston Elementary School
48.281
106.838
73.934
99.352
89.029
83.412
79.391
63.78
79.784
42.408
103.939
84.082
41.617
46.903
80.682
56.747
76.63
105.83
55.583
74.052
48.77
40.816
49.01
52.32
56.345
87.38
49.148
44.915
64.762
57.111
52.103
57.276
50
83.523
48.424
83.062
54.822
64.268
86.084
68.429
53.107
50.598
61.419
50.338
55.814
41.155
47.159
46.084
635
635
635
635
635
636
636
636
637
637
638
638
638
638
638
638
638
638
638
638
640
642
642
643
643
644
644
644
644
644
644
644
644
644
644
644
644
644
644
644
644
644
644
644
644
644
644
Colqui …
Purchase answer to see full
attachment

GradeAcers
Calculate your paper price
Pages (550 words)
Approximate price: -

Why Work with Us

Top Quality and Well-Researched Papers

We always make sure that writers follow all your instructions precisely. You can choose your academic level: high school, college/university or professional, and we will assign a writer who has a respective degree.

Professional and Experienced Academic Writers

We have a team of professional writers with experience in academic and business writing. Many are native speakers and able to perform any task for which you need help.

Free Unlimited Revisions

If you think we missed something, send your order for a free revision. You have 10 days to submit the order for review after you have received the final document. You can do this yourself after logging into your personal account or by contacting our support.

Prompt Delivery and 100% Money-Back-Guarantee

All papers are always delivered on time. In case we need more time to master your paper, we may contact you regarding the deadline extension. In case you cannot provide us with more time, a 100% refund is guaranteed.

Original & Confidential

We use several writing tools checks to ensure that all documents you receive are free from plagiarism. Our editors carefully review all quotations in the text. We also promise maximum confidentiality in all of our services.

24/7 Customer Support

Our support agents are available 24 hours a day 7 days a week and committed to providing you with the best customer experience. Get in touch whenever you need any assistance.

Try it now!

Calculate the price of your order

Total price:
$0.00

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Our Services

No need to work on your paper at night. Sleep tight, we will cover your back. We offer all kinds of writing services.

Essays

Essay Writing Service

No matter what kind of academic paper you need and how urgent you need it, you are welcome to choose your academic level and the type of your paper at an affordable price. We take care of all your paper needs and give a 24/7 customer care support system.

Admissions

Admission Essays & Business Writing Help

An admission essay is an essay or other written statement by a candidate, often a potential student enrolling in a college, university, or graduate school. You can be rest assurred that through our service we will write the best admission essay for you.

Reviews

Editing Support

Our academic writers and editors make the necessary changes to your paper so that it is polished. We also format your document by correctly quoting the sources and creating reference lists in the formats APA, Harvard, MLA, Chicago / Turabian.

Reviews

Revision Support

If you think your paper could be improved, you can request a review. In this case, your paper will be checked by the writer or assigned to an editor. You can use this option as many times as you see fit. This is free because we want you to be completely satisfied with the service offered.

Order your essay today and save 15% with the discount code DISCOUNT15