Homework Help is Here – Start Your Trial Now!
Math
Statistics
Suppose that a random sample of n = 5 was selected from the vineyard properties for sale in Sonoma County, California, in each of three years. The following data are consistent with summary information on price per acre for disease-resistant grape vineyards in Sonoma County. In Excel, carry out an ANOVA to determine whether there is evidence to support the claim that the mean price per acre for vineyard land in Sonoma County was not the same for each of the three years considered. Test at the 0.05 level and at the 0.01 level. 1996: 30000 34000 36000 38000 40000 1997: 30000 35000 37000 38000 40000 1998: 40000 41000 43000 44000 50000 I ran the ANOVA test in Excel but I am struggling to test at .05 and at the .01 level as well as making sure that the mean price per arce for vineyard land in Sonoma is not the same. The ANOVA test shows that it's not the same but I wanted to make sure.

Suppose that a random sample of n = 5 was selected from the vineyard properties for sale in Sonoma County, California, in each of three years. The following data are consistent with summary information on price per acre for disease-resistant grape vineyards in Sonoma County. In Excel, carry out an ANOVA to determine whether there is evidence to support the claim that the mean price per acre for vineyard land in Sonoma County was not the same for each of the three years considered. Test at the 0.05 level and at the 0.01 level. 1996: 30000 34000 36000 38000 40000 1997: 30000 35000 37000 38000 40000 1998: 40000 41000 43000 44000 50000 I ran the ANOVA test in Excel but I am struggling to test at .05 and at the .01 level as well as making sure that the mean price per arce for vineyard land in Sonoma is not the same. The ANOVA test shows that it's not the same but I wanted to make sure.

MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
See similar textbooks
icon
Related questions
Question

Hello, 

Here is the question: 

Suppose that a random sample of n = 5 was selected from the vineyard properties for sale in Sonoma County, California, in each of three years. The following data are consistent with summary information on price per acre for disease-resistant grape vineyards in Sonoma County.

In Excel, carry out an ANOVA to determine whether there is evidence to support the claim that the mean price per acre for vineyard land in Sonoma County was not the same for each of the three years considered. Test at the 0.05 level and at the 0.01 level.

1996: 30000 34000 36000 38000 40000
1997: 30000 35000 37000 38000 40000
1998: 40000 41000 43000 44000 50000

I ran the ANOVA test in Excel but I am struggling to test at .05 and at the .01 level as well as making sure that the mean price per arce for vineyard land in Sonoma is not the same. The ANOVA test shows that it's not the same but I wanted to make sure. 

Year Price Per Acre 1996 30,000.00 $ 34,000.00 $ 36,000.00 $ 38,000.00 $ 40,000.00 1997 $ 30,000.00 $ 35,000.00 $ 37,000.00 $ 38.000.00 $ 40,000.00 1998 40,000.00 $ 41,000.00 $ 43,000.00 $ 44,000.00 $ 50,000.00 Anova: Single Factor SUMMARY Groups Count Sum Average Variance Row 1 178000 35600 14800000 Row 2 180000 36000 14500000 Row 3 218000 43600 15300000 ANOVA Source of Variation SS df MS P-value F crit Between Groups 203200000 2 101600000 6.834080717 0.010440442 3.885293835 Within Groups 178400000 12 14866666.67 Total 381600000 14
Transcribed Image Text:Year Price Per Acre 1996 30,000.00 $ 34,000.00 $ 36,000.00 $ 38,000.00 $ 40,000.00 1997 $ 30,000.00 $ 35,000.00 $ 37,000.00 $ 38.000.00 $ 40,000.00 1998 40,000.00 $ 41,000.00 $ 43,000.00 $ 44,000.00 $ 50,000.00 Anova: Single Factor SUMMARY Groups Count Sum Average Variance Row 1 178000 35600 14800000 Row 2 180000 36000 14500000 Row 3 218000 43600 15300000 ANOVA Source of Variation SS df MS P-value F crit Between Groups 203200000 2 101600000 6.834080717 0.010440442 3.885293835 Within Groups 178400000 12 14866666.67 Total 381600000 14
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Anova and Design of Experiments
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman
SEE MORE TEXTBOOKS