(Answered) Place the following data in sheet 1nbspseven types of

Statistics

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

View complete question

Statistics and Probability, Statistics

Category:- Statistics and Probability
Reference No.:- M92812708
Price:- $20

Verified Expert

Priced at $40 Now at $20, Verified Solution

Have any Question?Write your Review or question?

Related Questions in Statistics and Probability

Introduction to epidemiology assignment -assignment should

Introduction to Epidemiology Assignment - Assignment should be typed, with adequate space left between questions. Read the following paper, and answer the questions below: Sundquist K., Qvist J. Johansson SE., Sundquist ...

Question 1 many high school students take the ap tests in

Question 1. Many high school students take the AP tests in different subject areas. In 2007, of the 144,796 students who took the biology exam 84,199 of them were female. In that same year,of the 211,693 students who too ...

Basic statisticsactivity 1define the following terms1

BASIC STATISTICS Activity 1 Define the following terms: 1. Statistics 2. Descriptive Statistics 3. Inferential Statistics 4. Population 5. Sample 6. Quantitative Data 7. Discrete Variable 8. Continuous Variable 9. Qualit ...

Question 1below you are given the examination scores of 20

Question 1 Below you are given the examination scores of 20 students (data set also provided in accompanying MS Excel file). 52 99 92 86 84 63 72 76 95 88 92 58 65 79 80 90 75 74 56 99 a. Construct a frequency distributi ...

Question 1 assume you have noted the following prices for

Question: 1. Assume you have noted the following prices for paperback books and the number of pages that each book contains. Develop a least-squares estimated regression line. i. Compute the coefficient of determination ...

Question 1 a sample of 81 account balances of a credit

Question 1: A sample of 81 account balances of a credit company showed an average balance of $1,200 with a standard deviation of $126. 1. Formulate the hypotheses that can be used to determine whether the mean of all acc ...

5 of females smoke cigarettes what is the probability that

5% of females smoke cigarettes. What is the probability that the proportion of smokers in a sample of 865 females would be greater than 3%

Armstrong faber produces a standard number-two pencil

Armstrong Faber produces a standard number-two pencil called Ultra-Lite. The demand for Ultra-Lite has been fairly stable over the past ten years. On average, Armstrong Faber has sold 457,000 pencils each year. Furthermo ...

Sppose a and b are collectively exhaustive in addition pa

Suppose A and B are collectively exhaustive. In addition, P(A) = 0.2 and P(B) = 0.8. Suppose C and D are both mutually exclusive and collectively exhaustive. Further, P(C|A) = 0.7 and P(D|B) = 0.5. What are P(C) and P(D) ...

The time to complete 1 construction project for company a

The time to complete 1 construction project for company A is exponentially distributed with a mean of 1 year. Therefore: (a) What is the probability that a project will be finished in one and half years? (b) What is the ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Statistics and Probability Expert