The following sample observations were randomly selected:

            
a. Not available in Connect.

b. Determine the regression equation. (Negative answer should be indicated by a minus sign. Do not round intermediate calculations. Round the final answers to 4 decimal places.)   

                                        
b =----  a =----

Y' = -----+-----  X

           
c. Determine the value of Y' when X is 26. (Do not round intermediate calculations. Round the final answer to 4 decimal places.)

How to do survival analysis in excel with this data

Life expectancy of males in years from 2005 to 2015

The postanesthesia care area (recovery room) at St. Luke’s Hospital in Maumee, Ohio, was recently enlarged. The hope was that the change would increase the mean number of patients served per day to more than 25. A random sample of 15 days revealed the following numbers of patients.

At the 0.01 significance level, can we conclude that the mean number of patients per day is more than 25?

  Click here for the Excel Data File

1. What is the decision rule? (Round your answer to 3 decimal places.)

2. Compute the value of the test statistic. (Round your answer to 3 decimal places.)

3. What is your decision regarding H₀?

4. Estimate the p-value.

Sports that involve a significant amount of running, jumping, or hopping put athletes at risk for Achilles Tendinopathy (AT), an inflammation and thickening of the Achilles tendon. A study in a medical journal looked at the diameter (in mm) of the affected and nonaffected tendons for patients who participated in these types of sports activities. Suppose that the Achilles Tendon diameters in the general population have a mean of 5.94 millimetres (mm) with a standard deviation of 1.92 mm. What average tendon diameters should we see 80% of the time in any random sample of 31 drawn from the general population?

The company manufactures chocolate bars with nominal weight of 115 g per bar. In order to to avoid risk of short changing, the mean weight is set as 117 g and SD of 2 g.

Assuming that 40 chocolate bars are selected, 97% of the sample means will be between what value? ( give the upper and lower value)

1) The proportion of people at shopping mall who wear red shirts is p = 0.18. What is the mean of the sampling distribution given a sample size of 50? What is the standard deviation? (Central Limit Throrem).

2) What is the probability given a random sample of 50 people at shopping mall that more than 20% of them are wearing red shirts?

3) CONF. INT Suppose you take a random sample of 50 people at shopping mall and find that 9 were wearing red shirts. Construct a 90% confidence interval for the true proportion.

4) CONF. INT] Suppose you take a random sample of 50 people at shopping mall and find that 4 were wearing red shirts. Construct a 95% confidence interval for the true proportion.

5) [CONF. INT] If the true proportion is p = 0.18, which of our confidence intervals contains it? Which don’t?

There are 2 full boxes of numbered tickets. The numbers in box A have a mean = 10 and a standard deviation = 5. For box B,mean= 10,SD= 9.

A) If you draw 64 numbers (with replacement) from box A, you expect the SUM to be about _____. give or take about ______. (Show your work)

B) If you draw 100 numbers (with replacement) from box B, you expect the MEAN to be about___, give or take about ____. (Show your work.)

C) If you average 25 numbers from box A, and you average 64 numbers from box B, which do you expect to be closer to 10 ? Explain.

A researcher is trying to predict test scores from student’s level of stress. What is the standardized regression equation for the following data taken from 10 students? The average level of stress for students is 9.50 with a standard deviation of 2.76. The average test score for students is 12.50 with a standard deviation of 5.13. The correlation stress and test scores is 0.88.

a) ZY’ = 0.54 (ZX) b) ZY’ = 1.32 (ZX) c) ZY’ = .88 (ZX) d) ZY’ = 1.86 (ZX)

A spinner has 8 equal sections numbered 1 to 8. what is the probability of th spinner stopping on a number that is a multiple of 3 or is greater than 5?

7.) The target temperature for a hot beverage the moment it is dispensed from a vending machine is 173◦F. A sample of 15 randomly selected servings from a newly manufactured vending machine gave a mean temperature of 170◦F with a standard deviation of 6.4◦F. Using our 6-step process, test that the mean tem- perature dispensed from this new machine differs from the target temperature.

How to do survival analysis in excel with this data

Life expectancy of females in years from 2005 to 2015

In an examination of holiday spending (known to be normally distributed) of a sample of 16 holiday shoppers at a local mall, an average of $54 was spent per hour of shopping. Based on the current sample, the standard deviation is equal to $21. Find a 90% confidence interval for the population mean level of spending per hour.

Structurally deficient highway bridges. Data on structurally deficient highway bridges is compiled by the Federal Highway Administration (FHWA) and reported in the National Bridge Inventory (NBI). For each state, the NBI lists the number of structurally deficient bridges and the total area (thousands of square feet) of the deficient bridges. The data for the 50 states (plus the District of Columbia and Puerto Rico). For future planning and budgeting, the FHWA wants to estimate the total area of structurally deficient bridges in a state based on the number of deficient bridges

a) Deplaned on scatterplot, can you use linear regression to predict SDArea based onNumberSD? Explain.

b) Develop a simple linear regression equation to predict SDArea based on NumberSD.

c) Is the model you found in (a) a good fit? Why or why not?

d) Predict the SDArea when the NumberSD is 1260 bridges. Find the corresponding residuals.

e) Build a 90% CI, confidence interval, for coefficient of NumberSD ( b₁).

f) Repeat (e) with a 95% CI. What is the difference between your answer in (e) and (f)?

The table below gives the number of parking tickets received in one semester and the GPA for five randomly selected college students who drive to campus. Using this data, consider the equation of the regression line, yˆ=b0+b1x, for predicting the GPA of a college student who drives to campus based on the number of parking tickets they receive in one semester. Keep in mind, the correlation coefficient may or may not be statistically significant for the data given. Remember, in practice, it would not be appropriate to use the regression line to make a prediction if the correlation coefficient is not statistically significant.

Number of Tickets 0 1 2 6 8

GPA 3.1 2.7 2.5 2.3 1.6

Step 1 of 6:

Find the estimated slope. Round your answer to three decimal places.

Step 2 of 6:

Find the estimated y-intercept. Round your answer to three decimal places.

Step 3 of 6:

Determine the value of the dependent variable yˆy^ at x=0x=0.

Step 4 of 6:

According to the estimated linear model, if the value of the independent variable is increased by one unit, then the change in the dependent variable yˆy^ is given by?

Step 5 of 6:

Determine if the statement "All points predicted by the linear model fall on the same line" is true or false.

Step 6 of 6:

Find the value of the coefficient of determination. Round your answer to three decimal places.