Questions
1. Use excel function exp( ) to calculate raising e to the power of (-2.5 +...

1. Use excel function exp( ) to calculate raising e to the power of (-2.5 + 2*X1 + 3*X2), where X1=5.6 and X2=3.

2. Denote the result from part 1 as Y, calculate the Y/(1+Y), and let us denote this ratio as prob, i.e., prob= Y/(1+Y). Demonstrate the quantity is sandwiched by this interval (0, 1) by trying different values of X1 and X2. Also realize the any quantity that is capped between 0 and 1 can lend itself to the interpretation of probability.

3. Use excel function ln() to calculate ln(67).

In: Math

The following sample observations were randomly selected. X: 5 6 2 7 11 Y: 3 6...

The following sample observations were randomly selected. X: 5 6 2 7 11 Y: 3 6 4 6 6 (a) Determine the 0.90 confidence interval for the mean predicted when X = 7. (Do not round the intermediate values. Round your answers to 3 decimal places.)

What is Confidence interval_____

(b) Determine the 0.90 prediction interval for an individual predicted when X = 7. (Do not round the intermediate values. Round your answers to 3 decimal places.) What is Prediction interval_____

In: Math

A recent article in BusinessWeek listed the “Best Small Companies.” We are interested in the current...

A recent article in BusinessWeek listed the “Best Small Companies.” We are interested in the current results of the companies' sales and earnings. A random sample of 12 companies was selected and the sales and earnings, in millions of dollars, are reported below.

Company

Sales
($ millions)

Earnings
($ millions)

Company

Sales
($ millions)

Earnings
($ millions)

Papa John's International

$

86.8

$

5.0

Checkmate Electronics

$

15.4

$

2.6

Applied Innovation

18.9

4.4

Royal Grip

10.8

1.7

Integracare

17.2

1.5

M-Wave

15.5

3.3

Wall Data

74.6

8.2

Serving-N-Slide

53.6

8.5

Davidson & Associates

59.9

6.9

Daig

26.6

6.0

Chico's FAS

49.6

4.1

Cobra Golf

66.5

11.0

Let sales be the independent variable and earnings be the dependent variable.

    

(a) Compute the correlation coefficient. (Round your answer to 3 decimal places.)

     

  Coefficient of correlation   

     

(b) Compute the coefficient of determination. (Round your answer to 3 decimal places.)

     

  Coefficient of determination   

     

(c) Determine the regression equation. (Round your answers to 4 decimal places.)

       

  The regression equation, with the coefficients, is YˆY^ = ______ +_____  X

     

(d)

For a small company with $50 million in sales, estimate the earnings. (Round your answer to 4 decimal places.)

      

  Estimated earnings $  millions  

In: Math

Let S denote the 10-element set {a,b,c,d,e,f,g,h,i,j}. How many ways can we construct a subset of...

Let S denote the 10-element set {a,b,c,d,e,f,g,h,i,j}. How many ways can we construct a subset of S of size 7 ? 120 How many ways can we construct a subset of S of size 7 containing the element j? 84 How many ways can we construct a subset of S of size 7 containing i but not j ? 28 How many ways can we construct a subset of S of size 7 containing h but neither i nor j ? 7 How many ways can we construct a subset of S of size 7 containing g but not h, i or j? 1 Note that every subset of S of size 7 falls into exactly one of the categories described in parts (b) through (e) above. Use that fact to derive a summation formula involving expressions nCr.

In: Math

Suppose researchers interested in the effects of adolescent exposure to mold in a household is associated...

Suppose researchers interested in the effects of adolescent exposure to mold in a household is associated with asthma. Researchers collected information about a sample of children living in homes determined to have a significant amount of potential mold exposure and determined that 154 out of the 213 children had asthma. After a sample of 428 households with not a sufficient amount of mold exposure, only 108 children were found to have asthma. A) Conduct a statistical test to determine if there is a significant risk difference for asthma based on exposure to mold at the alpha level of 0.05. B) Construct a confidence interval about your point estimate for the difference in risk between the groups.

In: Math

a. Find the mean, standard deviation, and five number summaries for each type of M&M (plain...

a. Find the mean, standard deviation, and five number summaries for each type of M&M (plain and peanut) for the number of M&Ms in each bag.

b. Use the information found in Step 1 to draw side by side boxplots, comparing the number of M&Ms in each bag of plain and peanut M&Ms. Discuss the shape of each.

c. Write a summary paragraph about your data. Make at least 4 different observations about your data and/or boxplots using your statistical knowledge.

Plain M&M:

(14, 14, 15, 16, 15, 14, 16, 15, 13, 14, 14, 14, 14, 14, 14, 15, 14, 16, 14, 14, 15, 16, 14, 15, 11, 15, 15, 15, 13, 15, 13, 16, 14, 14, 14, 15, 14, 15, 15, 14, 15, 15, 15, 14, 16, 13)

Peanut M&M:

(8, 8, 7, 6, 8, 7, 7, 8, 7, 6, 6, 7, 7, 7, 7, 8, 7, 8, 9, 7, 7, 8, 7, 7, 6, 7, 7, 8, 7, 7, 7, 7, 7, 6, 7, 8, 7, 7, 7, 5, 7, 7, 7, 7, 8, 7, 7, 8, 7, 7)

In: Math

You are studying the market value of home in Houston. You collect data from the recent...

You are studying the market value of home in Houston. You collect data from the recent sale of 30 single family homes. The data is organized and stored in an Excel file. The dataset includes the fair market value (in $thousands), land area of the property in acres, and age, in years of the 30 homes. Develop a multilinear regression model to predict the fair market value based on land area of the property (in acres) and age, in years.

The name of the Excel data file is HoustonHomes.xlsx. Import the data into SPSS and complete the assignment using SPSS.

  1. State the multiple regression equation.

  1. Interpret the meaning of the slopes, b1 and b2 , in this problem?

  1. Explain why the regression coefficient, b0, has no practical meaning in the context of this problem.

  1. Predict the mean fair market value for a house that has a land area of 0.25 acre and is 55 years old?

  1. Construct a 95% prediction interval estimate for the fair market value for an individual house that has a land area of 0.25 acre and is 55 years old.

Address Fair Market Value ($000) Property Size (acres) Age House Size (square feet) Rooms Baths Garage
9 Sycamore Road 522.9 0.2297 56 2448 7 3.5 2
21 Jefferson St 425.0 0.2192 61 1942 7 2.5 1
38 Hitching Post Lane 539.2 0.1630 39 2073 5 3 2
4 Poppy Lane 628.2 0.4608 28 2707 8 2.5 1
5 Daniel Drive 490.4 0.2549 56 2042 7 1.5 1
15 Francis Terrace 487.7 0.2290 98 2089 7 2 0
23 Guilfoy Street 370.3 0.1808 58 1433 7 2 0
17 Carlyle Drive 777.9 0.5015 17 2991 9 2.5 1
8 Craft Avenue 347.1 0.2229 62 1008 5 1 0
22 Beechwood Ct. 756.8 0.1300 25 3202 8 2.5 2
14 Fox Street 389.0 0.1763 64 2230 8 2 0
1 Raynham Road 889.0 1.3100 62 1848 7 2 1
2 Jerome Drive 452.2 0.2520 56 2100 6 2 0
7 Valentine Street 412.4 0.1148 22 1846 5 3 1
38 Jefferson Street 338.3 0.1693 74 1331 5 1 1
15 Inwood Road 334.3 0.1714 62 1344 8 1 0
29 Meadowfield Lane 437.4 0.3849 54 1822 6 2 1
13 Westland Drive 644.0 0.6545 56 2479 6 2.5 2
79 Valentine Street 387.8 0.1722 62 1605 6 3 0
13 Fairmont Place 399.8 0.1435 88 2080 11 2 0
1 Prestwick Terrace 356.4 0.2755 81 2410 6 1 1
11 Clement Street 346.9 0.1148 107 1753 8 2 0
7 Woodland Road 541.8 0.3636 55 1884 7 2 2
36 Elm Avenue 388.0 0.1474 51 2050 10 2 2
17 Duke Place 564.0 0.2281 50 2978 6 2.5 2
12 Prospect Avenue 454.4 0.4626 92 2132 7 1 0
1 Buckeye Road 417.3 0.1889 64 1551 6 2 0
30 Ann Street 318.8 0.1228 54 1129 5 1 0
26 Broadfield Place 519.8 0.1492 44 1674 7 2 1
16 Jackson Street 310.2 0.0852 104 1184 5 1 0

In: Math

Do you typically stop or speed up at a yellow traffic light? Ho: proportion who speed...

Do you typically stop or speed up at a yellow traffic light?

Ho: proportion who speed up = 0.70 Ha: proportion who speed up ≠ 0.70

Average: .4375  Standard Deviation: .4961

The sample size is 32 and our focus is who does speed up at the yellow light.

How many speeding tickets have you had in your life?

Ho: average tickets = 5 Ha: average tickets ≠ 5

Average: 7.03 Standard Deviation: 10.00

Test the hypotheses and include a full calculation of the test statistic, p-value, and state the full conclusion in words for both problems. Show all work.

In: Math

In a test of weight loss​ programs, 160 subjects were divided such that 32 subjects followed...

In a test of weight loss​ programs, 160 subjects were divided such that 32 subjects followed each of 5 diets. Each was weighed a year after starting the diet and the results are in the ANOVA table below. Use a 0.025 significance level to test the claim that the mean weight loss is the same for the different diets.

Source of Variation

SS

df

MS

F

​P-value

F crit

Between Groups

554.416

4

138.60402

4.4411

0.001999

2.869395

Within Groups

4837.455]

155

31.20939

Total

5391.871

159

Should the null hypothesis that all the diets have the same mean weight loss be​ rejected?

A.

YesYes​,

because the​ P-value is

greater thangreater than

the significance level.

B.

YesYes​,

because the​ P-value is

less thanless than

the significance level.

C.

NoNo​,

because the​ P-value is

less thanless than

the significance level.

D.

NoNo​,

because the​ P-value is

greater thangreater than

the significance level.

In: Math

As part of an annual review of its accounts, a discount brokerage selects a random sample...

As part of an annual review of its accounts, a discount brokerage selects a random sample of 27 customers. Their accounts are reviewed for total account valuation, which showed a mean of $32,500, with a sample standard deviation of $8,600. (Use t Distribution Table.)

What is a 95% confidence interval for the mean account valuation of the population of customers? (Round your answers to the nearest dollar amount.)

95% confidence interval for the mean account valuation is between $  and $  .

In: Math

A small regional carrier accepted 20 reservations for a particular flight with 17 seats. 13 reservations...

A small regional carrier accepted 20 reservations for a particular flight with 17 seats. 13 reservations went to regular customers who will arrive for the flight. Each of the remaining passengers will arrive for the flight with a 40% chance, independently of each other.
Find the probability that overbooking occurs.
Find the probability that the flight has empty seats.

Assume that a procedure yields a binomial distribution with a trial repeated n=5n=5 times. Use some form of technology to find the probability distribution given the probability p=0.299p=0.299 of success on a single trial.
(Report answers accurate to 4 decimal places.)

k P(X = k)
0
1
2
3
4
5

In: Math

The proportion of public accountants who have changed companies within the last three years is to...

The proportion of public accountants who have changed companies within the last three years is to be estimated within 4%. The 95% level of confidence is to be used. A study conducted several years ago revealed that the percent of public accountants changing companies within three years was 21. (Use z Distribution Table.) (Round the z-values to 2 decimal places. Round up your answers to the next whole number.)

a. To update this study, the files of how many public accountants should be studied?
b.

How many public accountants should be contacted if no previous estimates of the population proportion are available?

In: Math

Are America's top chief executive officers (CEOs) really worth all that money? One way to answer...

Are America's top chief executive officers (CEOs) really worth all that money? One way to answer this question is to look at row B, the annual company percentage increase in revenue, versus row A, the CEO's annual percentage salary increase in that same company. Suppose that a random sample of companies yielded the following data:

B: Percent increase

for company

21 10 15 23 15 29 20 30

A: Percent increase

for CEO

17 1 11 28 16 34 12 22

Do these data indicate that the population mean percentage increase in corporate revenue (row B) is different from the population mean percentage increase in CEO salary? Assume that the distribution of differences is approximately normal, mound-shaped and symmetric. Use a 5% level of significance. What is the alternate hypothesis?

In: Math

The Gravy Company has decided to launch a new advertisement campaign in grocery stores to promote...

The Gravy Company has decided to launch a new advertisement campaign in grocery stores to promote their products. The idea is to put small signs in the meat section (next to the Turkey, Ham, etc.) which read, "Get on board to the gravy train! The company wonders whether the different groups of consumers who eat different meats also have different gravy preferences. The table below is from a random sample of college students. The row denotes whether the student's family has gravy at Thanksgiving or not. The column denotes the type of meat served.

meat chicken ham don't know other roast beef tofurkey turducken turkey total
no 2 5 3 14 4 8 1 45 82
yes 10 24 2 21 7 12 2 814 892
total 12 29 5 35 11 20 3 859 974

Formulate a set of hypotheses to test whether the two variables are independent or dependent and perform the test.

In: Math

To test whether extracurricular activity is a good predictor of college success, a college administrator records...

To test whether extracurricular activity is a good predictor of college success, a college administrator records whether students participated in extracurricular activities during high school and their subsequent college freshman GPA.

Extracurricular
Activity

College
Freshman GPA

Yes

3.49

Yes

3.31

Yes

3.94

Yes

3.69

No

2.95

No

3.86

No

3.47

No

2.76

No

3.85

No

2.78

(a) Code the dichotomous variable and then compute a point-biserial correlation coefficient. (Round your answer to three decimal places.)


(b) Using a two-tailed test at a 0.05 level of significance, state the decision to retain or reject the null hypothesis. Hint: You must first convert r to a t-statistic.

Retain the null hypothesis OR Reject the null hypothesis.    

In: Math