Question

In: Statistics and Probability

Using the below data I need a statistical formula to show which of these categories a...

Using the below data I need a statistical formula to show which of these categories a total of 50 people did the best in in a memory test of words vs. pictures vs. numbers or if it is statistically not able to be proven "reject the null hypothesis"

Words Out of 20 Male & Female N=50 Pictures out of 18 Male & Female N=50 Numbers out of 18 Male & Female N=50
Words Pictures Numbers
16 17 12
15 16 12
17 15 11
14 16 14
17 14 14
16 17 16
17 14 8
14 16 9
19 17 15
10 9 15
12 16 13
14 15 12
11 14 9
11 14 10
14 15 17
11 13 14
13 13 12
13 13 12
12 16 12
15 17 11
11 14 10
16 16 10
12 13 16
12 9 8
9 11 11
341 360 303 totals
6.82 7.2 6.06 mean
2.564 2.2546 2.5219 Std. Deviation

Solutions

Expert Solution

here we use one-way anova with

null hypothesis H0: all three groups mean are equal

alternate Hypothesis Ha: atleast one group mean is different from other

since p-value between groups is less than typical alpha=0.05, so we reject H0 and conclude that atleast one group mean is different from other.

( here number of observation in each of the group is 25 accordingly analysis has been done, if it is different please revert back at earliest)

following information has been generated using ms-excel

Anova: Single Factor
SUMMARY
Groups Count Sum Average Variance
Column 1 25 341 13.64 6.573333
Column 2 25 360 14.4 5.083333
Column 3 25 303 12.12 6.36
ANOVA
Source of Variation SS df MS F P-value F crit
Between Groups 67.38667 2 33.69333 5.610361 0.00544 3.123907
Within Groups 432.4 72 6.005556
Total 499.7867 74

if number of observation is 50 then following information has been generated and found the p-value is more than typical alpha=0.05, so we accept H0 ( fail to reject H0)

within SS between SS
Group nj mean(xj-) s2 nj*xj- (n-1)s2 (xj--x-) nj(xj--x-)2
1 50 6.82 6.5733 341 322.0917 0.126667 0.80222222
2 50 7.2 5.0833 360 249.0817 0.506667 12.8355556
3 50 6.06 6.36 303 311.64 -0.63333 20.0555556
sum 150 20.08 18.0166 1004 882.8134 0 33.6933333
grand mean(x-) 6.693333
ANOVA
SOURCE DF SS MS F CRITICAL F(0.05) p-value
BETWEEN 2 33.69 16.84667 2.81 3.06 0.063737
WITHIN(ERROR) 147 882.81 6.005533
TOTAL 149 916.51

Related Solutions

Using the below data calculate the quadratic formula. Then calculate the following: i) Fixed cost ii)...
Using the below data calculate the quadratic formula. Then calculate the following: i) Fixed cost ii) Average total cost iii) Marginal cost d) Using your answers from part c) calculate fixed cost, average total cost, and marginal cost if 25 units Coefficient Std. Error t-ratio p-value const 2.22486 2.29906 0.9677 0.3347 q 0.00434763 0.000230941 18.83 <0.0001 sq_q 1.63160e-08 2.79915e-09 5.829 <0.0001
Provide a statistical trend analysis on the following data. Show this in a visual graph using...
Provide a statistical trend analysis on the following data. Show this in a visual graph using excel. Explain in detail the trend comparing Toys R Us to the other two corporations, Amazon and Target. Can this information be used to provide future trends in sales and possibly prevented bankruptcy for Toys R Us. Do you see any underlying patterns or behaviors? Net sales   In millions (other than stores)    2008   2009   2010   2011   2012   2013   2014   2015   2016   2017 13,794  ...
Hi, I need the Excel Formula for the below. Thanks much. A business takes out a...
Hi, I need the Excel Formula for the below. Thanks much. A business takes out a 10-year loan for $250,000 at 5.3% interest compounded monthly. What are the formulas to calculate how much interest the business will pay in the first year and how much the business will repay toward the principal? What are the resulting values? Calculate the total cost of the loan in terms of the total interest paid through the l0 years of the loan
I need show work also 6.) Use the pension formula (including a projection of future salary...
I need show work also 6.) Use the pension formula (including a projection of future salary levels) to determine the retirement benefits earned to date. FACTS: The company has a defined benefit plan Jessica's salary at the end of 2017 is $    119,000 Retirement expected after 45 years of service Retirement period is expected to be 20 years Interest Rate 4.0% Benefits are calculated as a formula as the product of: Service already provided 22 years Percentage 3.0% Final year's...
Use the data set which is labeled below and answer using regression output in excel i....
Use the data set which is labeled below and answer using regression output in excel i. Find the correlation coefficients between Y and X1, X2 and X3 and test the significance of population correlation coefficient using the value of r calculated for X2 and X3. ii. Estimate the regression equation for Y and X1, Y and X2 and report the results and explain the intercept and slope coefficients. iii. Check the significance or insignificance of the independent variables? and explain...
Calculate the pH of each aqueous solution: I need step to step solution please using formula...
Calculate the pH of each aqueous solution: I need step to step solution please using formula from; pH = -log [H3O+] pOH = -log[OH-] pH + pOH = 14 1)0.80 M lactic acid and 0.40 M lactate ion. 2) 0.10 mol of formic acid, HCOOH, and 0.10 mol of sodium formate, HCOONa in 1 L of water . 3) 0.30 M NH3 and 1.50 M NH4+
Identify and list various categories of data that are used in statistical analysis. Give few suitable...
Identify and list various categories of data that are used in statistical analysis. Give few suitable examples.
Solve the following questions by using Excel formula. Show me your data 1-      If you deposit...
Solve the following questions by using Excel formula. Show me your data 1-      If you deposit $20,000 in a bank account that pays 15% interest annually, how much will be in your account after 6 years? 2-      If you are planning to invest your money today in a secuirty that pay you $5,000,000 in 15 years with rate of return on your investment of 10% annually. How much you should invest? 3-      What's the future value of 7%, 7-year ordinary...
Explain reasons for using statistical measures R2, RAAE and RMAE when evaluating response surfaces. I need...
Explain reasons for using statistical measures R2, RAAE and RMAE when evaluating response surfaces. I need perfect answer for this question asap
I need solution and formula as clear.Otherwise , I will have to report the answer. Assume...
I need solution and formula as clear.Otherwise , I will have to report the answer. Assume that X and Y has a continuous joint p.d.f. as 28x2y3 in 0<y<x<1 interval. Otherwise the joint p.d.f. is equal to 0. a.Calculate Var(X) b.Calculate P(X< 0.1) c.Calculate P(X> 0.1) d.Calculate P(X>2) e.Calculate P(-2<X<0.1)
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT