how do I copy my word data to excel

I typed my report on word document and would like to copy them on excel 2013 in other to add table and graph

In regards to Statistics: the exploration and and analysis of data (7th edition), chapter 13, question 43. Part a of the question asks for the equation of an estimated regression line. The solution is already on chegg, but my question is: why are SSR, Se, and Sb still calculated, after y-hat=2.7...+(0.04...)x has already been solved for?

Questions 6-10 are related to the following As a statistics course assignment you are to build a 95% confidence interval for the mean monthly rental for two-bedroom apartments in Marion County. A random sample of 80 apartments yields the following data. 840 1550 560 1080 970 1560 830 1220 1390 1110 920 1150 1600 1310 610 1590 1100 720 720 1350 1020 1290 710 600 830 1190 1170 1470 1320 730 800 840 1130 690 900 1520 1050 1220 1400 1060 1420 560 1580 790 1240 1530 1010 510 540 1600 560 1520 1350 580 600 1600 1160 880 1320 720 1080 1400 620 1430 1560 800 1530 650 700 1400 1430 970 1230 1100 1370 1120 1290 1130 1010 1310 6 The point estimate of the mean monthly rental is, a 1038.45 b 1059.60 c 1081.25 d 1091.50 7 The variance of the sample mean is, a 1,374.275 b 1,649.130 c 34,631.738 d 109,942.025 8 The margin of error for the 95% confidence interval is, a 68.2 b 73.8 c 76.7 d 80.6 9 The upper end of the 95% interval estimate is, a 1123.9 b 1149.4 c 1165.3 d 1175.8 10 If you were asked to narrow the 95% margin of error to $25. How many apartments would you need to include in your sample? For planning value use $300. a 620 b 585 c 554 d 485.

Questions 1-5 are based on the following Let X be a normally distributed random variable. A random sample of size n = 9 yields the following data: x 98 93 61 75 58 75 95 77 70 1 The variance of the sample is, a 210.75 b 201.21 c 191.67 d 187.33 2 The variance of x̅ is, a 62.229 b 74.083 c 23.417 d 34.572 3 You want to build a 95% confidence interval for the population mean. The margin of error (MOE) for the interval is, a 12.836 b 11.159 c 10.705 d 9.485 4 The 95% interval estimate is, a 66.841 89.159 b 67.064 88.936 c 68.515 87.485 d 69.464 86.536 5 You want to build an interval estimate that would capture the population mean within ±3 from the sample mean 95% of the time. What is the minimum sample size to yield such an interval? Round the standard deviation from the above sample data to the nearest integer for the planning value. a 104 b 97 c 89 d 81

Suppose cattle in a large herd have a mean weight of 1158lbs and a standard deviation of 92lbs . What is the probability that the mean weight of the sample of cows would differ from the population mean by less than 12lbs if 55 cows are sampled at random from the herd? Round your answer to four decimal places.

The research around Leona’s Tacos has created quite a buzz and business is great. Leona is planning on expanding her menu and she’s going to start with a new taco filling. She is considering her own black bean mix “Savor” and Hadey’s famous braise of seitan “Praise”. She naturally performs a blind taste test with randomly selected judges from Avocado Park. Each judge is served a taco filled with either “Savor” or “Praise” and asked to assess the experience using a rubric that results in a score from 0-100. The results can be found in the Excel file “Savor v Praise.xlsx” on MyLab.

1. Identify the populations of interest.

2. Identify the variable of interest.

3. What type of variable is being studied here?

4. What would be a suitable parameter for determining if the taco

   filling receive different scores?

5. Write a null hypothesis for Leona’s study.

6. Write an alternative hypothesis for Leona’s study.

7. Explain what a Type II Error would look like in this context.

8. What conditions will need to be met in order for Leona to

   calculate a P-Value?

9. Are any assumptions necessary to meet the conditions in question

   7?

10. Calculate the P-Value for the hypotheses you wrote in

questions 5 and 6.
11.What should Leona’s decision be?
12. Write a detailed summary of Leona’s conclusions.

64   95
72   77
83   85
75   77
88   82
70   75
71   99
91   80
71   76
83   73
59   73
79   72
63   88
81   86
69   83
87   83

Please give an explanation as well. Thanks.

What is the number of permutations π of {1, . . . , n} so that there is no triple i < j < k with

π(j) < π(i) < π(k)?

Total plasma volume is important in determining the required plasma component in blood replacement therapy for a person undergoing surgery. Plasma volume is influenced by the overall health and physical activity of an individual. Suppose that a random sample of 44 male firefighters are tested and that they have a plasma volume sample mean of x = 37.5 ml/kg (milliliters plasma per kilogram body weight). Assume that σ = 7.60 ml/kg for the distribution of blood plasma.

(a) Find a 99% confidence interval for the population mean blood plasma volume in male firefighters. What is the margin of error? (Round your answers to two decimal places.)

(b) What conditions are necessary for your calculations? (Select all that apply.)

-σ is unknown

-n is large

-the distribution of weights is normal

-σ is known

-the distribution of weights is uniform

(c) Interpret your results in the context of this problem.

-99% of the intervals created using this method will contain the true average blood plasma volume in male firefighters.

-The probability that this interval contains the true average blood plasma volume in male firefighters is 0.01.

-The probability that this interval contains the true average blood plasma volume in male firefighters is 0.99.

-1% of the intervals created using this method will contain the true average blood plasma volume in male firefighters.

(d) Find the sample size necessary for a 99% confidence level with maximal margin of error E = 2.50 for the mean plasma volume in male firefighters. (Round up to the nearest whole number.)
_________ male firefighters

Short answer

A. What are two tests that are used to check for equal variance in two samples?

B. Why can we not simply use multiple t-tests to determine if there is a difference between treatments if we have an experiment with many treatments?

C. What are the two graphical methods to detect deviations from normality, and how do they work (one sentence description of each)?

D. When would you use an a priori or an a posteriori tests? Give one example of each

Allen's hummingbird (Selasphorus sasin) has been studied by zoologist Bill Alther.† Suppose a small group of 13 Allen's hummingbirds has been under study in Arizona. The average weight for these birds is x = 3.15 grams. Based on previous studies, we can assume that the weights of Allen's hummingbirds have a normal distribution, with σ = 0.36 gram.

(a) Find an 80% confidence interval for the average weights of Allen's hummingbirds in the study region. What is the margin of error? (Round your answers to two decimal places.)

lower limit:

upper limit:

margin of error:

(b) What conditions are necessary for your calculations? (Select all that apply.)

-σ is known

-normal distribution of weights

-n is largeσ is unknown

-uniform distribution of weights

(c) Interpret your results in the context of this problem.

-The probability that this interval contains the true average weight of Allen's hummingbirds is 0.20.

-The probability that this interval contains the true average weight of Allen's hummingbirds is 0.80.

-The probability to the true average weight of Allen's hummingbirds is equal to the sample mean.

-There is a 20% chance that the interval is one of the intervals containing the true average weight of Allen's hummingbirds in this region.

-There is an 80% chance that the interval is one of the intervals containing the true average weight of Allen's hummingbirds in this region.

(d) Find the sample size necessary for an 80% confidence level with a maximal margin of error E = 0.12 for the mean weights of the hummingbirds. (Round up to the nearest whole number.)

________ hummingbirds

[2 pts] Narrow confidence intervals give us more precise estimates of our parameter. What two quantities does the researcher control that affect the width of a confidence interval, and how can the researcher change them to result in narrower confidence intervals?

A random sample of 12 MSU students were surveyed and asked “How much did you spend on textbooks this semester?”

What type of plot should be used to display these data? Select all that apply.

Histogram

Segmented bar chart

Dotplot

Scatterplot

In order to create a theoretical confidence interval from these data, what must be assumed? Select one.

The sample is representative of all MSU students.

The distribution of textbook costs reported is roughly symmetric.

The students were honest in their responses.

With this sample size, we can never use theoretical methods of analysis.

[2 pts] Assume it is valid to use a theoretical confidence interval to analyze these data. The sample mean was $284.90 and the sample standard deviation was $96.10. Use these values and a multiplier of 2.201 to create a 95% confidence interval for the true mean.

[2 pts] Interpret the confidence interval in the context of the problem.

[2 pts] What is meant by having “95% confidence” in the interval?

[2 pts] If we had sampled 50 MSU students instead of 12 and gotten the same sample mean and sample standard deviation, which of the following statements would be true? Select all that apply.

The variability between individuals in our sample would decrease.

The variability between means from many samples would decrease.

The confidence interval width would decrease.

The center of the confidence interval would decrease.

Studies are often done by pharmaceutical companies to determine the effectiveness of a treatment program. Suppose that a new AIDS antibody drug is currently under study. It is given to patients once the AIDS symptoms have revealed themselves. Of interest is the average (mean) length of time in months patients live once starting the treatment. Two researchers each follow a different set of 40 AIDS patients from the start of treatment until their deaths. The following data (in months) are collected.

Researcher A: 3; 4; 11; 15; 16; 17; 22; 44; 37; 16; 14; 24; 25; 15; 26; 27; 33; 29; 35; 44; 13; 21; 22; 10; 12; 8; 40; 32; 26; 27; 31; 34; 29; 17; 8; 24; 18; 47; 33; 34

Researcher B: 3; 14; 11; 5; 16; 17; 28; 41; 31; 18; 14; 14; 26; 25; 21; 22; 31; 2; 35; 44; 23; 21; 21; 16; 12; 18; 41; 22; 16; 25; 33; 34; 29; 13; 18; 24; 23; 42; 33; 29

Complete the tables using the data provided. (Enter exact numbers as integers, fractions, or decimals.)

Researcher A

Researcher B

1. You have a number of variables -- a response variable and some proposed predictors. A correlation matrix may help to give an idea of the strength of the linear relationships present. For the purposes of regression analysis, what would be desirable in terms of … a) …the observed correlation between each proposed predictor and the response variable? (2) b) …the observed correlations among the predictors themselves?

(2) 2. Explain the fact that, over the course of a year, the value of r for the DOW adjusted closing value and the S&P500 adjusted closing value is about 0.98 or higher.

(3) 3. Reconcile these observations: In a regression output, the p-value of the F-test is 2.36 E-06, while the value of R2 is 0.21. (3)

4. What causes the problem of multicollinearity? (2)

5. Interpretation of a regression coefficient: Suppose that in a SLR model, annual salary (in thousands of dollars) is estimated as a function of years of education. With explicit reference to the variable units, interpret the value b1 = 3.42. (3)//15

We must show our work.

1. A sample of 81 observations is taken from a normal population with a standard deviation of 5. The sample mean is 40. Determine the 80% confidence interval for the population mean. (Hint: Confidence Interval for a Population mean with population standard deviation (σ) known)