Chapter 14, Problem 14.32AC

Plese show steps on how to put into exel spreedsheet

Maple syrup is a non-negligible nutritional source of manganese. It is made from the sap of two species of maple: the sugar maple and the black maple. To see if there is a significant difference between the manganese content of these two species of maple, we measured the manganese content (in mg per 100g syrup) for a sample of sugar maples and a sample of black maples. The data is summarized by the Minitab output below: Two-sample T for Sugar Maple Black Maple group N Mean St Dev SE Mean Sugar Maple 20 Black Maple 12 3.55 0.29 Find: (i) a point estimate for ₁-2, where ₁ and 2 are the average manganese contents of the sugar maple, respectively the black maple; (ii) the standard error of X₁ - X₂. A) (i) -0.07; (ii) 0.101 C) (i) -0.26; (ii) 0.097 E) (i) -0.07; (ii) 0.035 3.29 0.22 0.049 0.084 B) (i) -0.26; (ii) 0.188 D) (i) -0.26; (ii) 0.101

In a hypothetical study conducted by environmental officers of the success of trawler fishing effort, data were collected on 196 fishing trawlers in Peru. The dataset trawlers.csv contains the following variables: Column 1 2 3 4 5 Variable Measured power of boat engine (horse power) Net size relative to maximum permitted (percent) Percent of fish shoals spotted by radar that were reached Number of fishing trips per year Total annual catch (in tonnes) Label power net radar trips totcatch

A researcher is interested in studying the relationship between commute time (defined as the number of minutes it takes a person to get to work in the morning) and job satisfaction (defined on a scale from 1=very dissatisfied to 5=very satisfied). The researcher believes that a person with a longer commute time will have lower job satisfaction. The researcher surveys 20 Valley commuters and finds the following data. Respond to questions 1 and 2 based on these data.   Commuter Length of Commute (minutes) Job Satisfaction(1=very dissatisfied;5=very satisfied) Commuter 1 10 4 Commuter 2 65 1 Commuter 3 30 4 Commuter 4 40 2 Commuter 5 15 5 Commuter 6 20 5 Commuter 7 60 2 Commuter 8 50 1 Commuter 9 45 3 Commuter 10 20 3 Commuter 11 30 4 Commuter 12 35 4 Commuter 13 20 5 Commuter 14 30 4 Commuter 15 40 2 Commuter 16 10 5 Commuter 17 20 5 Commuter…

please answer the question fully!

TABLE 10.2 A course can be taken for credit either by attending lecture sessions at fixed times and days, or by doing online sessions that can be done at the student's own pace and at those times the student chooses. The course coordinator wants to determine if these two ways of taking the course resulted in a significant difference in achievement as measured by the final exam for the course. Table 10.2 gives the scores on an exami- nation with 45 possible points for one group of n₁ = 9 students who took the course online, and a second group of n₂ = 9 students who took the course with conventional lectures. Do these data present sufficient evidence to indicate that the average grade for students who take the course online is significantly higher than for those who attend a conventional class? Test Scores for Online and Classroom Presentations Online Classroom 32 37 35 28 41 44 35 31 34 35 31 29 25 34 40 27 32 31

This problem is based on information taken from The Merck Manual (a reference manual used in most medical and nursing schools). Hypertension is defined as a blood pressure reading over 140 mm Hg systolic and/or over 90 mm Hg diastolic. Hypertension, if not corrected, can cause long-term health problems. In the college-age population (18-24 years), about 9.2% have hypertension. Suppose that a blood donor program is taking place in a college dormitory this week (final exams week). Before each student gives blood, the nurse takes a blood pressure reading. Of 190 donors, it is found that 26 have hypertension. Do these data indicate that the population proportion of students with hypertension during final exams week is higher than 9.2%? Use a 5% level of significance. -What is the value of the sample test statistic? (Round your answer to two decimal places.) - Find the P-value of the test statistic. (Round your answer to four decimal places.)

This problem is based on information taken from The Merck Manual (a reference manual used in most medical and nursing schools). Hypertension is defined as a blood pressure reading over 140 mm Hg systolic and/or over 90 mm Hg diastolic. Hypertension, if not corrected, can cause long-term health problems. In the college-age population (18-24 years), about 9.2% have hypertension. Suppose that a blood donor program is taking place in a college dormitory this week (final exams week). Before each student gives blood, the nurse takes a blood pressure reading. Of 190 donors, it is found that 26 have hypertension. Do these data indicate that the population proportion of students with hypertension during final exams week is higher than 9.2%? Use a 5% level of significance. Find the P-value of the test statistic. (Round your answer to four decimal places.) ANSWER IS NOT 2.711

Your younger brother, a fourth form practical geography student wishes to test whether there could be some relationship between annual visits to a local market by all residents surrounding that market. After a well-designed field study he obtains the following figures: Number of visits per year 21 13 19 18 17 17 14 20 10 11 Residence distance from market (KM) 1.0 2.0 3.0 4.0 5.0 6.0 7.0 8.0 9.0 10.0 From the information above, what is the dependent variable and what is the explanatory variable?                                                                                                             Using (i) above, obtain the regression equation of Yi on Xi. Hence, estimate the residence distance from the market (in KM) if the number of visits are 16 visits Sketch your results in (ii) above. What conclusion can you draw from your sketch?