All calculations should be done in Word using Equation Editor and all charts and graphs should be done in Excel.

profiletutor4helpyou
 (Not rated)
 (Not rated)
Chat

All calculations should be done in Word using Equation Editor and all charts and graphs should be done in Excel.

 

The next 6 questions refer to the following scenario. A property manager is interested in exploring the relationship between the same price of a residential property and the appraised land value, home value and size value. The appraiser selects a random sample of 40 properties sold in a particular year.

What can be said about the relationship between the price and the value predictors at a 5% level of significance?

 

 

ANOVA

 

 

 

df

SS

MS

FSTAT

Among Values

?

20274470.12

??

??

With Values

37

??

5707.31

 

Total

??

??

 

 

 

1) What is the hypothesis scenario?

2) What are the degrees of freedom for Among Values?

3) What is the SST?

4) What is the MSA?

5) What is the FSTAT?

6) What is the conclusion? Is there evidence of a mean difference in values of appraisal predicators?

 

Use the following scenario to answer the next 4 questions.  The Computer Anxiety Rating Scale (CARS) measures an individual’s level of computer anxiety, on a scale from 20 to 100.  Researchers at Miami University administered CARS to 172 business students.  One of the objectives of the study was to determine whether there are differences in the amount of computer anxiety experienced by students with different majors.  They found the following:

 

 

ANOVA

 

 

 

df

SS

MS

FSTAT

Among Majors

5

3,172

634.4

4.837

With Values

162

21,246

131.1481

 

Total

167

24,418

 

 

 

 

Majors

n

Mean

Marketing

28

44.37

Management

28

43.18

Other

28

42.21

Finance

28

41.80

Accountancy

28

37.56

MIS

28

32.21

 

7) What is the MSA?

8) What is the FSTAT?

9) At the 0.05 level of significance, is there evidence of a difference in the mean computer anxiety experienced by different majors?

10) If the results in (9) indicate that it is appropriate, use the Tukey-Kramer procedure to determine which majors differ in mean computer anxiety.

 

  • 11 years ago
All calculations should be done in Word using Equation Editor and all charts and graphs should be done in Excel.
NOT RATED

Purchase the answer to view it

blurred-text
  • attachment
    data.xlsx
  • attachment
    solution.docx