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

  Conduct a z-test to determine whether the following two

conduct a z-test to determine whether the following two samples indicate that the population proportions are

  Question about statistics-hypothesis testing

Nut problem: Manager claims 336g and a population standard deviation of 11g. We sample 64 bags and find

  How to reduce the number of elementary school students

A new reading program may reduce the number of elementary school students who read below grade level. The company that developed this program supplied materials

  Choose the appropriate alternative hypothesis to test

Choose the appropriate alternative hypothesis to test if the population proportions differ. All population proportions differ from 1/6.Not all population.

  Find the probability of the sum is 7

Two six-sided (balanced) dice are thrown. Find the probabilities of a= 5 does not occur on either throw;and the sum is 7;

  Percentage of persons enrolled in college

In a certain city, there are 100,000 persons age 18 to 24. A simple random sample of 500 such persons is drawn, of whom 198 turn out to be currently enrolled in college.

  Question on testing proportions

The manufacturer of Feel Better aspirin advertises that 60% of pediatricians recommend Feel Better for children under twelve. Safe and Sound, a rival manufacturer

  A project being analyzed by pert has 38 activities 16 of

question 1 a project being analyzed by pert has 38 activities 16 of which are on the critical path. if the estimated

  Construct a confidence interval for the population average

A random sample of 100 people reveals that the sample average is 3.2 and the sample standard deviation is 2.1. Construct a 95% confidence interval for the population average.

  Nondecreasing sequence of numbers

Let {Xn } be a submartingale. Show that EXn is a nondecreasing sequence of numbers, and give an example to show that Xn - EXn is not necessarily a martingale. Hint: Consider the uniqueness in the Doob decomposition.

  Construct a confidence interval for the proportion of teens

Construct a 95% confidence interval for the proportion of teens who find texting while driving very distracting

  Find the critical value corresponding to a sample size

Write a statement that correctly interprets the confidence interval found in question 5. Find the critical value corresponding to a sample size of 19 and a confidence level of 99%. Find the critical value corresponding to a sample size of 19 and a ..

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