Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

2. The owner of a small delivery services business wants to estimate how long delivery will take based on two (2) factors: the total distance

image text in transcribed
2. The owner of a small delivery services business wants to estimate how long delivery will take based on two (2) factors: the total distance of the trip in miles and the daily price of gas in Peso. To conduct the analysis, he takes a random sample of ten (10 past trips and recorded the following information: Miles Traveled (X,) Gas Price (X3) Travel time (hrs.) (Y) 89 184.73 7 66 153.46 5.4 78 181.84 6.6 111 187.13 7.4 44 171.74 4.8 77 171.74 6.4 80 145.76 7 66 168.85 5.6 109 170.29 7.3 76 156.34 6.4 a. Using MS Excel, determine the sample statistics (coefficients) and formulate the estimated multiple regression equation. b. What is the estimated travel time if a trip travels 89 miles and consumes 184.73 pesos for gas? C. At a 5% alpha level, test and interpret the individual significance of the parameters

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Brief Calculus & Its Applications

Authors: Larry J Goldstein, David C Lay, David I Schneider, Nakhle I Asmar

13th Edition

0321888510, 9780321888518

More Books

Students also viewed these Mathematics questions

Question

Explain the factors that influence peoples values.

Answered: 1 week ago

Question

please assist with question 1a and 1b and 1c and 1d

Answered: 1 week ago

Question

Discuss the effectiveness of a national infrastructure for HRD

Answered: 1 week ago