Place the output on the same sheet as the data

Assignment Help Basic Statistics
Reference no: EM131972170

Place the following data in Sheet 1. Seven types of root-stock were used in an apple orchard grafting experiment. The following data represent the extensions growth (cm) after four years. Test the claim that the mean growth is the same for all types of root-stock. Write hypothesis steps. Use Excel 1-way ANOVA test to find the test value and p-value. Place the output on the same sheet as the data.

Crop 1 Crop 2 Crop 3 Crop 4 Crop 5 Crop 6 Crop 7

2569 2074 2505 2838 1532 2569 3447

2928 2885 2315 2351 2552 2074 3085

2865 3378 2667 3001 3083 2505 3308

3844 3906 2390 2439 2330 2838 3291

3027 2782 3021 2199 2079 1532 3366

2336 3018 3231 3318 2945 2416 3100

3211 3383 3140 3601 2610 1990 3037

In Sheet 2: Use the Excel directions below to make a scatter plot for the Temperature in Fahrenheit and the number of cricket chirps per sec. Find the Best Fit Line using Excel. State what the slope means with respect to the problem.

Temp 88.6 71.6 93.3 84.3 80.6 75.2 69.7 82 69.4 83.3 79.6 82.6 80.6

Chirps 20 16 19.8 18.4 17.1 15.5 14.7 17.1 15.4 16.2 15 17.2 16

Reference no: EM131972170

Questions Cloud

What should x be for the expected payoff to be zero : Suppose you spend $1 to mark two spots (numbers). If the house hits both of your numbers, you win X dollar(s). Otherwise, you lose that $1.
Organization assignment and progress report : Project Code: XXSE 60108 Career path on organization assignment and progress report with literature review
Calculate cash collections in each of the four quarters : The company has a 60-day collection period. Calculate cash collections in each of the four quarters by completing the following.
Sample proportion of those who prefer chocolate : If a sample of 100 Americans is taken, what is the probability that the sample proportion of those who prefer chocolate is greater than 0.30?
Place the output on the same sheet as the data : Write hypothesis steps. Use Excel 1-way ANOVA test to find the test value and p-value. Place the output on the same sheet as the data.
What pretax amounts did s and l earnings : What pretax amounts did S&L include in its 2016 and 2017 earnings as a result of this investment?
Calculate the frequency one would expect : Calculate the frequency one would expect when surveying 400 people. Fill in the table below, rounding to two decimal places.
Determine the orientation of your solar system : Solar System Design: Discuss layout of your house and determine orientation of your solar system. Calculate daily Solar Irradiance Collectable for each month
How much harborcraft show current and non-current liability : In the December 31, 2015 financial statements, how much should HarborCraft show as current and non-current liability?

Reviews

Write a Review

Basic Statistics Questions & Answers

  Interpret the standard deviation in context

This list represents the numbers of paid vacation days required by law for different countries. (Source: 2009 World Almanac and Book of Facts)

  What is the probability that all 7 volunteers pick the

a local microbrewery believes it produces the best tasting dark beer in baltimore. to make its case 7 volunteers are

  Tests on the ground and randomly assign

Validity: True story: I once spoke to a retired professor who used to teach general studies geography. His grading technique was to throw the papers/tests on the ground and randomly assign the same grade to each pile (without even reading the pape..

  Least-squares estimates of the slope

Postulate a linear two-parameter model as in Eq (16.19), obtain least-squares estimates of the slope and intercept, and test hy- potheses that these parameters are not signi?cantly different from zero. Plot the data versus the model ?t and c..

  Explain how can determine the probabilities

Find information on a random circumstance in the news. Identify the circumstance and possible outcomes, and assign probabilities to the outcomes.

  Develop a regression model to predict costs based on the

question 1 in 1999 lehman brothers estimated that 48 of its investment bank traders took diverse forms of soft drugs.

  What is parametric counterpart to the wilcoxon rank sum test

What is the parametric counterpart to the Wilcoxon rank sum test? Compare the assumptions involved in using the respective tests.

  Assumptions concerning three-factor

Fold over the last column in the design of Table 6.8a and confirm that, on the usual assumptions concerning three-factor and higher order interactions

  Report the percentage of people who are morbidly obese

Compare this with an estimate from 2005 that 3% of people in the United States at that time were morbidly obese.

  Compute fraction of workers in a factory on the job

An economist wants to know what fraction of workers in a factory sometimes smoke marijuana on the job. She collects a random sample of 100 workers.

  Proportion test using large sample test

To test whether the significant difference between two proportion test using large sample test.

  Identify the product associated with the penguin

Marketing and Consumer Behavior. A successful company usually has high brand-name and logo recognition among consumers.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd