Reference no: EM131975055
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
|
Finding the wacc for janicek power company
: Finding the WACC. Given the following information for Janicek Power Co., find the WACC. Assume the company's tax rate is 35 percent.
|
|
Sample proportion of those who prefer chocolate is greater
: 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?
|
|
Prepare the entry to record the interest expense at october
: Schuss Inc. issued euro 3,000,000 of 10%, 10-year convertible bonds on April 1, 2015 at 98. Prepare the entry to record the interest expense at October 1, 2015.
|
|
What is the amount of its retained earnings
: Non current Liabilities 60,000. If Turner has total paid-in capital of $50,000 on December 31, what is the amount of its retained earnings
|
|
What the slope means with respect to the problem
: Use the Excel directions below to make a scatter plot for the Temperature in Fahrenheit and the number of cricket chirps per sec.
|
|
What is the bond price if the bond promised ytm
: A 15-year corporate bond pays $40 interest every six months. What is the bond's price if the bond's promised YTM is 5.5 percent?
|
|
What is the npv of the ten-year project
: What is the firm's WACC? Based on their Initial investment $1,000,000, what is the NPV of this 10- year project using the firm's WACC that you calculated in.
|
|
What is the amount of retained earnings at december
: chumacher Company uses the perpetual inventory system, and it engaged in the given transactions. What is the amount of Retained Earnings at December 31, 2015.
|
|
Test the claim that the proportion of people
: Test the claim that the proportion of people who own cats is larger than 60% at the 0.05 significance level.
|