Use the data given in the table to answer the following questions. The data represents the...

Use the data given in the table to answer the following questions. The data represents the average number of miles that a salesperson travels in a day verses the number of sales made each month.

Miles, x	24	32	75	41	76	107	32	46	112
Sales, y	76	58	190	112	141	235	24	147	188

(a) What is the value of the correlation coefficient for this set of data? Round to 3 decimal places.

(b) What is the equation of the Regression Line for this set of data? Round values to two decimal places.

(c) Predict the number of sales an associate could expect to make if he travelled an average of 108 miles each day. Round to two decimal places.

Expert Solution

a)

x	y	(x-x̅)²	(y-ȳ)²	(x-x̅)(y-ȳ)
24	76	1336.31	2928.01	1978.06
32	58	815.42	5200.01	2059.17
75	190	208.64	3586.68	865.06
41	112	382.42	328.01	354.17
76	141	238.53	118.57	168.17
107	235	2157.09	11001.68	4871.51
32	24	815.42	11259.57	3030.06
46	147	211.86	285.23	-245.83
112	188	2646.53	3351.12	2978.06

	ΣX	ΣY	Σ(x-x̅)²	Σ(y-ȳ)²	Σ(x-x̅)(y-ȳ)
total sum	545	1171	8812.222222	38058.9	16058.44
mean	60.56	130.11	SSxx	SSyy	SSxy

correlation coefficient , r = Sxy/√(Sx.Sy) = 0.877

b)

sample size ,   n =   9
here, x̅ = Σx / n=   60.56   ,     ȳ = Σy/n =   130.11

SSxx =    Σ(x-x̅)² =    8812.2222
SSxy=   Σ(x-x̅)(y-ȳ) =   16058.4

estimated slope , ß1 = SSxy/SSxx =   16058.4   /   8812.222   =   1.8223

intercept,   ß0 = y̅-ß1* x̄ =   19.7612

so, regression line is   Ŷ =   19.76 +   1.82 *x

c)

Predicted Y at X= 108 is
Ŷ = 19.76119 + 1.822292 * 108 = 216.57

milcah answered 1 year ago

Use the chart of data below to answer the following questions. This data represents enrollment for...

Use the chart of data below to answer the following questions. This data represents enrollment for the Fall semesters 2013 – 2017 years. Part a: Is being part time dependent upon gender? Part b: Is the probability of being a male student enrolled (or female) dependent upon year? Part c: Create a probability tree, with the appropriate probabilities using the data from the table. Assume the tree is showing the PT or FT probabilities given the gender of the student....

Answer the following questions using the data given in the table. Use the T-Test Paired Two...

Answer the following questions using the data given in the table. Use the T-Test Paired Two Sample for Means to arrive at the solutions to the questions below. Use an alpha value of 0.01 Home Appraiser 1 Appraiser 2 A $235,000 $228,000 B $210,000 $205,000 C $231,000 $219,000 D $242,000 $240,000 E $205,000 $198,000 F $230,000 $223,000 G $231,000 $227,000 H $210,000 $215,000 I $225,000 $222,000 J $249,000 $245,000 K $199,000 $201,000 1 What is the value for the test...

The following table provides data for a project. Use the data to answer the following questions...

The following table provides data for a project. Use the data to answer the following questions Activity Immediate Predecessor Time Estimates (weeks) Optimistic Most Likely Pessimistic Expected Variance A - 6 7 14 B - 8 10 12 C A 2 3 4 D A 6 7 8 E B,C 5 5.5 9 F B,C 5 7 9 G D,E 4 6 8 H F 2.5 3 3.5 Draw a network to represent the above project. What is the critical...

1. Use this data table for the bromination of acetone to answer the following questions; Experiment...

1. Use this data table for the bromination of acetone to answer the following questions; Experiment [CH3COCH3] (M) [Br2] (M) [H+] (M) Rate (M s-1) 1 0.3 0.05 0.05 0.000057 2 0.3 0.10 0.05 0.000057 3 0.3 0.05 0.10 0.000120 4 0.4 0.05 0.20 0.000310 5 0.4 0.05 0.05 0.000076 a) Determine the reaction order with respect to each of the three reactants and write the rate law. b) What is the value of the rate constant including proper units?

Use the following to answer Questions. The table includes summary of data concerning advertising expenditures and...

Use the following to answer Questions. The table includes summary of data concerning advertising expenditures and computer sales for ACME electronics. Ad Expenditures ($1000) Computer Sales ($1000) 2.5 6.1 3.8 4.9 3.1 5.9 2.1 6.8 What is the linear regression equation for the data? Y = 8.88 – 1.03x Y = 5.22 – 1.92x Y = 6.85 + 1.03x Y = 3.72 + 2.46x What is the standard error of the regression model? .2219 .3276 .7324 .9777 What is the...

Use the information provided below to answer the following questions: Represents the initial demand curve; Represents...

Use the information provided below to answer the following questions: Represents the initial demand curve; Represents individual new demand curve associated with positive network externalities and; the Draw a graph showing positive network externalities in economics Calculate pure price effect Calculate bandwagon effect Calculate total effect

Use the data given below to answer the following question(s). The following table exhibits the age...

Use the data given below to answer the following question(s). The following table exhibits the age of second-hand furniture and the corresponding prices. Use the table to answer the following question(s). (Hint: Use scatter diagram and XLMiner where necessary.) Number of Years Values 2 1856 14 348 7 1020 5 1530 10 349 8 780 9 653 3 1830 10 750 6 1300 Q1. What is the relationship between the age of the furniture and their values? _ _________________ Q2....

Use the following data to answer the questions below:

Use the following data to answer the questions below: Q VC MC AVC 1 $10 ___ ___ 2 16 ___ ___ 3 20 ___ ___ 4 25 ___ ___ 5 31 ___ ___ 6 38 ___ ___ 7 46 ___ ___8 55 ___ ___9 65 ___ ___ a. Calculate the marginal cost and average variable cost for each level of production.b. How much would the firm produce if it could sell its product for...

The following questions use the table below on soybean oil. Answer the following questions about an...

The following questions use the table below on soybean oil. Answer the following questions about an end user needing to purchase soybean oil. One soybean oil contract is 60,000 pounds (lbs). Now Later Cash Soybean Meal Market $0.335/lb $0.346/lb Futures Soybean Meal Market $0.3000/lb $0.311/lb 1) Is the individual concerned about price increasing or decreasing? 2) What is the initial action in the futures market: buy or sell? 3) What is the cash price paid/received by the individual later? 4)...

Values in the table below are approximate. Use these to answer the following questions and to...

Values in the table below are approximate. Use these to answer the following questions and to compare health impact of the two diseases. R-naught Incubation period Contagious Period COVID-19 2.5 10 days 2-3 days before symptoms to 10 days after Rabies 1.5 Several months From symptoms to 10 days after symptoms Recall that R-naught is the average number of additional cases that directly result from a single person bringing it into a fully susceptible community. Below, compare in the impact...

Question