Question

In: Statistics and Probability

The purpose of this assignment is to calculate and interpret an ANOVA table. For this assignment,...

The purpose of this assignment is to calculate and interpret an ANOVA table. For this assignment, use IBM SPSS Statistics.

Part 1:

Using the "Example Dataset," assess this statement using ANOVA: "People with different levels of education exercise for different amounts of time during the week."

Select and conduct the appropriate ANOVA test to assess the statement. Export the ANOVA table to a Word document.

Part 2:

In 250-500 words, discuss the following regarding the use of ANOVA.

  1. Describe when the use of ANOVA is more appropriate than the use of a t-test.
  2. Describe which ANOVA test you used and why.
  3. Interpret the results by (a) stating the reason the study or test was done; (b) presenting the main results, including explaining the within and between subjects variation and the F-ratio from the ANOVA table; (c) explaining what the results mean, including discussing whether there is a statistically significant difference between education groups and amount of exercise; and (d) making suggestions for future research.
    Sex Education_Level*** Minutes_Exercise
    Female 2 90
    Male 2 50
    Female 3 65
    Male 1 20
    Female 1 50
    Female 2 25
    Female 3 110
    Male 1 50
    Female 2 40
    Male 2 80
    Female 3 120
    Male 1 80
    Female 1 60
    Male 3 150
    Male 2 75
    Male 1 80
    Female 2 110
    Male 3 80
    Male 2 100
    Female 1 0
    Female 2 50
    Female 3 200
    Male 2 60
    Male 1 65
    Female 1 40
    Male 3 65
    Female 3 70
    Female 1 45
    Male 3 75
    Male 3 50

Solutions

Expert Solution

Solution:

Part 1:

Null hypothesis: There is a no statistically significant difference between education groups and amount of exercise

Alternative hypothesis: There is a statistically significant difference between education groups and amount of exercise

Results are summarized below:

Part 1:

Null hypothesis: There is a no statistically significant difference between education groups and amount of exercise

Alternative hypothesis: There is a statistically significant difference between education groups and amount of exercise

We can observe from table p-value is greater than level of significance 0.05 therefore; we do not reject the null hypothesis of equal variances. Assumption of homogeneity of variances satisfied for performing ANOVA.

P-value is less than level of significance 0.05 therefore we reject the null hypothesis and conclude that there is statistically significant difference between three education level and amount of exercise.

Part 2:

ANOVA test is used when we want to compare more than two or more unrelated groups, whereas two sample t-test is used when we want compare two independent groups.

We have used here, One way ANOVA because researcher wants to check whether there is a statistically significant difference between education groups and amount of exercise. Here we have only one factor or independent variable. A one-way ANOVA only involves one factor or independent variable, whereas there are two independent variables in a two-way ANOVA. ... In a one-way ANOVA, the one factor or independent variable analyzed has three or more categorical groups. A two-way ANOVA instead compares multiple groups of two factors

In given Problem, We want to analyze is there statistically significant difference between three different education level considering amount of exercise. Amount of exercise differs between three education levels or not.

From the ANOVA table we can see between group variability is low compared to within group variability. F-ratio is 5.21 and table value of F at 0.05 for DF1=2 and DF2=29 is 3.32 i.e F-ratio is greater than F-table value therefore; we reject the null hypothesis of equal groups.

From the above results we can reveal that amount of exercise differs between three education levels.

We can study with more data is amount of exercise differs between Males and females with different education levels.


Related Solutions

1. Use the following table to calculate the correlation coefficient (r).             and Interpret the results...
1. Use the following table to calculate the correlation coefficient (r).             and Interpret the results in words. Credibility X Persuasion Y 59 64 54 60 59 63 58 72 71 78 55 69 55 69 54 67 2.Explain Type I error
1. Using the information in the table below, calculate the Index of Segregation by occupation. Interpret...
1. Using the information in the table below, calculate the Index of Segregation by occupation. Interpret the index number that you calculated and provide an explanation of it's meaning. Occupation Men Women Managerial 11,005 9,387 Professional and Technical 12,063 13,952 Sales 7,601 6,953 Clerical/Administrative 3,751 14,128 Service 6.465 10,066 Production/Craft 13,516 1,283 Operatives 9,302 3,007 Laborers 3,631 1,011 Total 67,334 59,787 **Note: All numbers are in thousands** 2. Carefully explain the two broad potential causes for the extent of gender...
Calculate the F* ratio and write the complete ANOVA table for this data set. do by...
Calculate the F* ratio and write the complete ANOVA table for this data set. do by hand, show work Red: 9, 11, 10, 9, 15 Green: 20, 21, 23, 17, 30 Black: 6, 5, 8, 14, 7
Purpose of Assignment The purpose of this assignment is to allow the students to become familiar...
Purpose of Assignment The purpose of this assignment is to allow the students to become familiar with and practice the measurement of Net Present Value (NPV), payback, and Weighted Average Cost of Capital (WACC) using Microsoft® Excel®. Assignment Steps Resources: Microsoft® Excel®, Capital Budgeting Decision Models Template Calculate the following problems using Microsoft® Excel®: Calculate the NPV for each project and determine which project should be accepted. Project A Project B Project C Project D Inital Outlay (105,000.000) (99,000.00) (110,000.00)...
Rate of Return for Stocks and Bonds Purpose of Assignment The purpose of this assignment is...
Rate of Return for Stocks and Bonds Purpose of Assignment The purpose of this assignment is to allow the student an opportunity to calculate the rate of return of equity and debt instruments. It allows the student to understand the effects of dividends; capital gains; inflation rates; and how the nominal rate of return affects valuation and pricing. The assignment also allows the student to apply concepts related to CAPM, WACC, and Flotation Costs to understand the influence of debt...
1- What is the purpose of ANOVA ? 2- What are the assumptions of ANOVA? 3-...
1- What is the purpose of ANOVA ? 2- What are the assumptions of ANOVA? 3- When and how should you use multiple comparison procedures for evaluating pairwise combinations of the group means?
Question 1 a) For the data in Homework 2, Question 1, calculate the ANOVA table. Use...
Question 1 a) For the data in Homework 2, Question 1, calculate the ANOVA table. Use the ANOVA Table to conduct an F-Test to see if the model is significant (use α = 0.05). Data: Size (Xi) 12 15 18 21 24 27 Price (Yi) 60 85 75 105 120 110 b) Give a 95% confidence interval for the mean sale price for 2000 sq. ft. houses. c)   Give a 95% prediction interval for the sale price of an individual...
Purpose of Assignment The purpose of the assignment is to develop students' abilities in using data...
Purpose of Assignment The purpose of the assignment is to develop students' abilities in using data sets to apply the concepts of sampling distributions and confidence intervals to make management decisions. Assignment Steps Resources: Microsoft Excel®, The Payment Time Case Study, The Payment Time Case Data Set Review the Payment Time Case Study and Data Set. Develop a 700-word report including the following calculations and using the information to determine whether the new billing system has reduced the mean bill...
1. Complete the following table: Nature of Test Purpose Example t-test Analysis of Variance (ANOVA) Correlation...
1. Complete the following table: Nature of Test Purpose Example t-test Analysis of Variance (ANOVA) Correlation Regression 2. Identify the type of test you would conduct to answer the following questions: 1. Are compensation packages at firms different for male and female employees? 2. Is job satisfaction of employees related to organizational commitment? 3. Is rent approximately equal in the seven emirates of the UAE? 4. Does stress lead to weight loss? 5. Does job satisfaction influence organizational commitment? 6....
Using the Payback Method, IRR, and NPV Problems Purpose of Assignment The purpose of this assignment...
Using the Payback Method, IRR, and NPV Problems Purpose of Assignment The purpose of this assignment is to allow the student to calculate the project cash flow using net present value (NPV), internal rate of return (IRR), and the payback methods. Assignment Steps Resources: Corporate Finance Calculate the following time value of money problems in Microsoft Excel or Word document. You must show all of your calculations. If you want to accumulate $500,000 in 20 years, how much do you...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT