Excel File Edit View Insert Format Tools Data Window Help 100% , Sat 10:38 PM St
ID: 204557 • Letter: E
Question
Excel File Edit View Insert Format Tools Data Window Help 100% , Sat 10:38 PM Stephanie Berrio BIO 200 Bird Data Insert Page Layout Formulas Data Review View Bing Maps itable Recommended Tatie Pictures Shapes PivotTables My Ads-ins People Graph ATS Behavior ATS (Obs) Exp. Glean Grab & Fly Hold & Peck 10.4 104707.56 111 1.86 Grab & Fly 9.488.36 850 9.4 26.6 Hold & Peck R.36 07.56 16 19 13 Scratch & Peck 68.03 34 1156 111 Scratch & Peck 53 35 Behavior WBN (Obs) Exp. Behavior BCc(bs)x(0-2 (op2/E 4.2 2.8 3.2 17.64 7.84 10.24 77.44 17.64 4.20 57.76 Grab & Fly Hold & Peck Peck Scratch & Peck 187 18.44 31.14 5.45 0.02 29.16 2.75 Grab &Fly; Hold & Peck 114 12996 1226 10.6 10.6S492.36 29.37 10.6 10.6 0.16 Scratch & Peck 92.168.69 29.17 Behavior WTs (obs) Exp. BehaviorSCJ (Obs) Exp.OE(0-E2 (o-Epp2/E 10.2 104.04 10.20 0.14 s.08 208 43264 42.42 Glean 2Grab&Fly; 3 Hold & Peck 229 057 1.29 10.2 Grab & Fy Hold & Peck 72 51.84 484 s8.31 12 19 5 Scratch& Peck 4.84 0.47 Scratch & Peck 7.00 31.71 51 leight Substrate Behavior + EdnExplanation / Answer
Ans
Chi squire text done to know the significant level of eperimental or obtained value verses expected value.
For each of your calculated value of X i.e called chi-suire value get the P value from Table i.e called level of significane.
In this data sheet the values were obtained after calculation i.e
Chi Squire Value calculation-
To calculate the chi square statistic x2 by completing the following steps:
1. For each observed number in the table subtract the corresponding expected number (O — E).
2. Square the difference [(O —E)2 ].
Divide the squares obtained for each cell in the table by the expected number for that cell [(O - E)2 / E ].
From the Chi-squire table , get the degree of freedom i.e n-1, where n is the different types of samples.
if you get P value less than 0.05 or less than that it is called singificant that means your data is accepted at 5% singificant level.
If the P value is greater than 0.05 i.e not singificant that means nul-hypothesis is being rejected.
In summary-
A chi-squared test, also written as 2 test, is any statistical hypothesis test where the sampling distribution of the test statistic is a chi-squareddistribution when the null hypothesis is true.
A chi-squared test can be used to attempt rejection of thenull hypothesis that the data are independent.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.