nfatal disease akin to leprosy. This test can identify patients before the onset of symptoms in order to begin early treatment. The group tested 50,000 people across different villages from the Stormlands and recorded their findings in the table below. The presence of the disease was validated by later onset of symptoms. Disease Present Disease Not Present Tested Positive 54 36 Tested Negative 9 49,901 Calculate the following, showing all calculations: 1) Disease Prevalence 2) Sensitivity 3) Specificity 4) Positive Predictive Value 5) Negative Predictive Value Would you consider this a good diagnostic test? Justify your answer.

How much do wild mountain lions weigh? Adult wild mountain lions (18 months or older) captured and released for the first time in the San Andres Mountains gave the following weights (pounds):

68

105

131

129

60

64

Assume that the population of x values has an approximately normal distribution.

(a) Use a calculator with mean and sample standard deviation keys to find the sample mean weight x and sample standard deviation s. (Round your answers to one decimal place.)

x = lb

s = lb

(b) Find a 75% confidence interval for the population average weight μ of all adult mountain lions in the specified region. (Round your answers to one decimal place.)

lower limit	lb
upper limit	lb

Suppose you gather the following test scores from you fellow students: 92,71,67,81,73,90,76,76,85,77,62,99.
A.The upper quartile is 85
B.The interquartile range is 15.5
C.The lower quartile is 71
D.The median quartile is 76

Respond to the following in a minimum of 175 words, please type response:

The standard error of the estimate of the mean is represented by the equation: σ√n Discuss what this equation means, using your own words and explain why we use it. Consider how it relates to the fact that we are making assumptions about the population and not just the sample.

1a.) If a constant c is added to each xi in a sample, yielding yi = xi + c, how do the sample mean and median of the yis relate to the mean and median of the xis? Verify your conjectures. Verify using a made-up example.

1b.) If each xi is multiplied by a constant c, yielding yi=cxi, answer the question of part (a). Again, verify your conjectures. Verify using a made-up example.

PLEASE SHOW HOW TO CALCULATE EACH STEP IN EXCEL.

Siders Breakfast Foods Inc., produces a popular brand of raisin bran cereal. The package indicates it contains 25.0 ounces of cereal. To ensure that the firm makes good in its marketing promo claim regarding box weight content, the Siders inspection department makes hourly check on the production process. As part of the hourly check, four boxes are selected and their contents weighed. The results for 25 samples are reported below.

Sample Number	Weight-1	Weight-2	Weight-3	Weight-4
1	25.1	24.4	25.6	23.2
2	23.2	23.9	25.1	24.8
3	25.6	24.5	25.7	25.1
4	22.5	23.8	24.1	25
5	23.2	24.2	22.3	25.7
6	22.6	24.1	20	24
7	23	26	24.9	25.3
8	24.5	25.1	23.9	24.7
9	24.1	25	23.5	24.9
10	25.8	25.7	24.3	26
11	24.5	23	23.7	24
12	25.1	24.4	25.6	23.2
13	23.2	24.2	23	25.7
14	23.1	23.3	24.4	24.7
15	24.6	25.1	24	25.3
16	24.4	24.4	22.8	23.4
17	25.1	24.1	23.9	26.2
18	24.5	24.5	26	26.2
19	25.3	24.5	24.3	25.5
20	24.6	25.3	25.5	24.3
21	24.9	24.4	25.4	24.8
22	23.2	24.2	22.3	25.7
23	24.8	24.3	25	25.2
24	23.2	24.2	23	25.7
25	24.8	24.3	25	25.2

1. Develop the appropriate control charts to evaluate and monitor the boxing process (10 pts)
2. What do the control charts tell you about the process during the 25-hour inspection period (i.e. Do a thorough interpretation and analysis of the charts.)? (10 pts)

3. An FDA regulation controlling the contents of packaged food items states that no more than 5 percent of the items produced and sold can contain less than 95 percent of the stated/labeled weight. Assuming that the standard deviation of the process, when in control or is operating as expected, is 0.90, determine if Siders Breakfast Foods, Inc., is in compliance or not in compliance with the FDA regulation given these parameters, i.e. process mean of 25 ounces and standard deviation of 0.90. Explain and show evidence supporting your conclusion. (10 pts). What should Siders Breakfast do if they discover their process to be in violation of the Federal regulation? (5 pts)

   (Assume that the content weight follows the normal distribution).

The accompanying data set consists of observations on shower-flow rate (L/min) for a sample of n = 129 houses:

4.6	12.3	7.1	7.0	4.0	9.2	6.7	6.9	11.5	5.1
11.2	10.5	14.3	8.0	8.8	6.4	5.1	5.6	9.6	7.5
7.5	6.2	5.8	2.3	3.4	10.4	9.8	6.6	3.7	6.4
8.3	6.5	7.6	9.3	9.2	7.3	5.0	6.3	13.6	6.2
5.4	4.8	7.5	6.0	6.9	10.8	7.5	6.6	5.0	3.3
7.6	3.9	11.9	2.1	15.0	7.2	6.1	15.3	18.4	7.2
5.4	5.5	4.3	9.0	12.7	11.3	7.4	5.0	3.5	8.2
8.4	7.3	10.3	11.9	6.0	5.6	9.5	9.3	10.4	9.7
5.1	6.7	10.2	6.2	8.4	7.0	4.8	5.6	10.5	14.6
10.8	15.5	7.5	6.4	3.4	5.5	6.6	5.9	15.0	9.6
7.8	7.0	6.9	4.1	3.6	11.9	3.7	5.7	6.8	11.3
9.3	9.6	10.4	9.3	6.9	9.8	9.1	10.6	4.5	6.2
8.3	3.2	4.9	5.0	6.0	8.2	6.3	3.8	6.0

(a) Construct a stem-and-leaf display of the data. (Enter numbers from smallest to largest separated by spaces. Enter NONE for stems with no values.)

Steams /              Leaves

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

(b) What is a typical, or representative, flow rate?

L/min

(c) Does the display appear to be highly concentrated or spread out?

spread out.

highly concentrated in the middle.

highly concentrated, except for a few values on the positive side.

highly concentrated, except for a few values on the negative side.

(d) Does the distribution of values appear to be reasonably symmetric? If not, how would you describe the departure from symmetry?

Yes, the distribution appears to be reasonably symmetric.

No, the data are skewed to the right, or positively skewed.

No, the data are skewed to the left, or negatively skewed.

No, the distribution of the values appears to be bimodal.

(e) Would you describe any observation as being far from the rest of the data (an outlier)?

Yes, the value 2.1 appears to be an outlier.

Yes, the value 15.5 appears to be an outlier.

Yes, the value 18.4 appears to be an outlier.

No, none of the observations appear to be an outlier.

35. The Center for Medicare and Medical Services reported that there were 295,000 appeals for hospitalization and other Part A Medicare service. For this group, 40% of first-round appeals were successful (The Wall Street Journal, October 22, 2012). Suppose 10 firstround appeals have just been received by a Medicare appeals office.

PLEASE SHOW HOW TO COMPUTE ANSWERS IN EXCEL USING EXCEL FORMULAS

a. Compute the probability that none of the appeals will be successful.

b. Compute the probability that exactly one of the appeals will be successful.

c. What is the probability that at least two of the appeals will be successful?

d. What is the probability that more than half of the appeals will be successful?

Grades on an english test can be modeled as a normal distribution with mean 80 and standard deviation 5.

A) if the english department is awarding students with test grades in the top 5%, find the lowest grade a student needs to receive the award.

B) A student is randomly selected from the class so the distribution of this student's test grade is N(80,5), what is the probability that this student scored above a 90?

C) What is the probability that the student in part b scored exactly a 90?

D) If 5 students are randomly selected from the class. what is the probability that exactly 3 of them scored above a 90?

E) If 20 students are randomly selected from the class what is the probability that at least 12 of them scored above an 80?

How do you perform hypothesis testing on multiple regression data from ANOVA table step-by-step? Please provide example.

Many regions along the coast in North and South Carolina and Georgia have experienced rapid population growth over the last 10 years. It is expected that the growth will continue over the next 10 years. The director gathered the following sample information.

Family		Food		Income		Size
1		$3.84		$73.98		1
2		4.08		54.90		2
3		5.76		53.20		4
4		3.48		52.02		1
5		4.20		65.70		2
6		4.80		53.64		4
7		4.32		79.74		3
8		5.04		68.58		4
9		6.12		165.60		5
10		3.24		64.80		1
11		4.80		138.42		3
12		3.24		125.82		1
13		7.20		77.58		7
14		6.40		94.15		5
15		6.60		135.76		8
16		5.40		141.30		3
17		6.00		36.90		5
18		5.40		56.88		4
19		3.36		71.82		1
20		4.68		69.48		3
21		4.32		54.36		2
22		5.52		87.66		5
23		4.56		38.16		3
24		5.40		43.74		7
25		5.90		62.40		6

(a-1)

Develop a correlation matrix. (Round your answers to 3 decimal places. Negative amounts should be indicated by a minus sign.)

	Food	Income
Income
Size

(b-1)

Determine the regression equation. (Round your answers to 3 decimal places. Leave no cells blank - be certain to enter "0" wherever required.)

The regression equation is: Food =  +  Income +  Size.

(b-2)

How much does an additional family member add to the amount spent on food? (Round your answer to the nearest dollar amount.)

Another member of the family adds $  to the food bill.

(c-1)

What is the value of R2? (Round your answer to 3 decimal places.)

(c-2)

State the decision rule for 0.05 significance level. H0: β1 = β2 = 0; H1: Not all βi's are 0. (Round your answer to 2 decimal places.)

Source	DF	SS	MS	F	p
Regression
Error
Total

(c-3)

Complete the ANOVA (Leave no cells blank - be certain to enter "0" wherever required. Round SS, MS to 3 decimal places and F to 2 decimal places.)

(d-1)

Complete the given below table. (Leave no cells blank - be certain to enter "0" wherever required. Do not round the intermediate calculations. Round T to 2 decimal places and all other values to 3 decimal places.)

Predictor	Coef	SE Coef	T	P
Income
Size

A regional planner is studying the demographics in a region of a particular state. She has gathered the following data on nine counties.

Country	Median Income		Median Age		Coastal
A	$47,963		56.4		1
B	49,585		58.9		1
C	46,440		57.5		1
D	46,391		41.2		1
E	34,806		39.4		0
F	39,416		41.2		1
G	35,549		41.3		0
H	30,796		33.5		0
J	32,233		21.7		1

(a)	Is there a linear relationship between the median income and median age? (Round your answer to 3 decimal places.)

(Click to select)NoYes, the correlation of Income and Median Age is .

(b)	Which variable is the "dependent" variable?
	Median Income Median Age

(c-1)

Use statistical software to determine the regression equation. (Round your answers to 2 decimal places.)

Income =  +  Median Age.

(c-2)

Interpret the value of the slope in a simple regression equation. (Round your answer to the nearest whole number.)

For each year increase in age, the income increases $  on average.

(d)	Include the aspect that the county is "coastal" or not in a multiple linear regression analysis using a "dummy" variable. Does it appear to be a significant influence on incomes? (Negative amounts should be indicated by a minus sign. Round your answers to 2 decimal places.)

Income =  +  Median Age +  Coastal

(e)	Test each of the individual coefficients to see if they are significant. (Round your answers to 2 decimal places. Negative amounts should be indicated by a minus sign. Leave no cells blank - be certain to enter "0" wherever required.)

Predictor	T	P
Median Age
Coastal

A portfolio manager expects to purchase a portfolio of stocks in 60 days. In order to hedge against a potential price increase over the next 60 days, she decides to take a long position on a 60-day forward contract on the S&P 500 stock index. The index is currently at 1150. The continuously compounded dividend yield is 1.85 percent. The discrete risk-free rate is 4.35 percent. Calculate the no-arbitrage forward price on this contract.

One hundred students were placed into two groups. The two groups were the South Beach diet and Keto diet. Below are the data for pounds lost after 1 month of dieting. Assume the data are normal and that the sample size is 100 (but, use the values you have). Tell me if there is a difference between the two diets. Show all of your work.

SB	Keto
2.5	3.5
3.2	3.7
3.0	4.0
5	4.1
2.3	4.0
2.7	2.5
1.0	2.3

The following data are from 10 individuals that were treated with 2 different drugs that are said to reduce acid in the stomach. Below are the pH’s of the stomach contents after giving the drugs to each patient. Tell me if one of the drugs are more effective than the other. Remember that a low pH is more acidic.

Pepcid	Prilosec
2.3	3.1
2.4	2.7
2.7	3.1
3.0	3.2
3.1	2.1