All calculations should be done in Word using Equation Editor and all charts and graphs should be done in Excel.
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
Purchase the answer to view it

- data.xlsx
- solution.docx