The dataset 'Delivery' shows the cost of delivery for different locations in the state of Karnataka...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The dataset 'Delivery' shows the cost of delivery for different locations in the state of Karnataka >Charges-Cost of Delivery. >Distance-Distance to the delivery address. >Weight- Weight of the consignment > Boxes - Number of boxes. A) Construct a simple linear regression model to understand the effect of distance on delivery charges. Based on results obtained, infer the relationship between delivery charges and distance. (3 marks) B) Construct a multiple linear regression model to assess effect of different variables like distance, weight and boxes. Detail your interpretations. (3 marks) C) Compare both models and comment. (2 marks) Charge Distance Weight Воxes 92.50 29 183 1 157.60 96 135 3 34.20 13 37 1 74.40 26 79 122.30 88 92 113.90 70 85 5 64.80 62 37 1 119.60 61 68 8. 51.80 14 61 67.90 26 80 4 56.90 50 15 71.40 59 10 114.20 93 39 3 110.30 59 70 84.60 69 39 121.70 86 86 4 102.10 53 96 3 86.90 34 92 2 74.80 49 75 1 153.20 93 90 146.80 89 96 6. 162.50 51 141 87.60 93 18 1 25.80 3 12 6. 54.40 49 37 1 123.90 76 84 8. 85.20 48 80 4 81.80 58 22 76.60 51 12 6. 143.00 47 117 7 The dataset 'Delivery' shows the cost of delivery for different locations in the state of Karnataka >Charges-Cost of Delivery. >Distance-Distance to the delivery address. >Weight- Weight of the consignment > Boxes - Number of boxes. A) Construct a simple linear regression model to understand the effect of distance on delivery charges. Based on results obtained, infer the relationship between delivery charges and distance. (3 marks) B) Construct a multiple linear regression model to assess effect of different variables like distance, weight and boxes. Detail your interpretations. (3 marks) C) Compare both models and comment. (2 marks) Charge Distance Weight Воxes 92.50 29 183 1 157.60 96 135 3 34.20 13 37 1 74.40 26 79 122.30 88 92 113.90 70 85 5 64.80 62 37 1 119.60 61 68 8. 51.80 14 61 67.90 26 80 4 56.90 50 15 71.40 59 10 114.20 93 39 3 110.30 59 70 84.60 69 39 121.70 86 86 4 102.10 53 96 3 86.90 34 92 2 74.80 49 75 1 153.20 93 90 146.80 89 96 6. 162.50 51 141 87.60 93 18 1 25.80 3 12 6. 54.40 49 37 1 123.90 76 84 8. 85.20 48 80 4 81.80 58 22 76.60 51 12 6. 143.00 47 117 7
Expert Answer:
Answer rating: 100% (QA)
a We run the following steps in minitab to carry out the regression analysis 1 Enter the given values in different columns 2 Go to Stat then regressio... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
For a simple linear regression model where ? i ?s are independent and normally distributed with zero means and equal variances a~, show that, Y and have zero covariance. Yi = a 3r, + ei, = 1, 2.......
-
Multiple charges at different locations are said to be in equilibrium if the force acting on any one of them is identical in magnitude and direction to the force acting on any of the others. Suppose...
-
A regression model has 3 independent variables and 20 observations, and the calculated Durbin-Watson d statistic is 0.91. What, if any, conclusion will be reached in testing for autocorrelation of...
-
Three Zero Coupon Bonds (ZCB) are issued on the market. They each have face value of 100 and maturity, respectively, of 1 year, 3 years and 4 years. Assume the first bond is sold for 99.01, the...
-
List four types of false entries a fraudster can make in the victim organizations books to conceal receivables skimming.
-
The Short-Line Railroad is considering a $100,000 investment in either of two companies. The cash flows are as follows: a. Using the payback method, what decision should be made? b. Explain why the...
-
Dee Hock recommends that managers spend what percentage of their time managing the employees for whom they have direct responsibility? A. 0%. B. 50%. C. 75%. D. 100%.
-
Refer to the information in Exercise 8-17. For the coming year, Triumph Corporation has told Julius Company that it will be switched to an activity- based pricing system or it will be dropped as a...
-
39: Harry purchases stock for $300. When the value of the stock rises to $900, Harry sells stock to Wendy for $500. Question 40 options: (A) Harry is not taxed on any gain. (B) Harry is taxed on gain...
-
The figure below shows an initially stationary block of mass m on a floor. A force of magnitude F = 0.550mg is then applied at upward angle ? = 24. (a) What is the magnitude of the acceleration of...
-
A brass tie bar of length 700mm and diameter 30mm undergoes a change in temperature from 40 degree celsuis to 130 degree celsuis. the linear expansivity of copper is 19 x 10^-6 C^-1 and the modulus...
-
2) Consider the Circuit below. Determine the equivalent capacitance of the circuit and the charges and voltages across all 4 capacitators for arbitrary Voltage, V. Determine the total energy stored...
-
Social media plan on gaming industry please Your Client Option 1: Create a social media plan for gaming industry. You can brand yourself as an expert/influencer, promote an idea, offer advice, start...
-
Tesla, the world's largest carmaker (as determined by market capitalization), understands that their primary target market responds well to brands that focus on social responsibility. Tesla's senior...
-
What surprised you most about services provider in your daily life? Has being more aware about the foundations of service marketing changed the way you view your interaction with service providers?...
-
Consider the following figure. P (MPa) 8 6 4 2 i 0 0 1 2 3 4 5 6 V (m) (a) Determine the work done on a fluid that expands from i to f as indicated in the figure. MJ (b) How much work is done on the...
-
Assessment of Objective 2 - Use properties of exponents/logarithms to solve given problems. Problem: Solve for x: log(3x+5)+4 = 6
-
-x/2 x/4 If A = -x/2 and A-1 =6 then x equals
-
Each of the following managers has been given certain decision- making authority. Classify each manager according to the type of responsibility center he or she manages. 1. Manager of the...
-
The CEO of Smith Snacks Corp. is concerned with the amount of resources currently spent on customer warranty claims. Each box of snacks is printed with the following logo: Satisfaction guaranteed, or...
-
Sarah Miracle has her own chain of music stores, Miracle Music. Her stores sell musical instruments, sheet music, and other related items. Music lessons and instrument repair are also offered through...
-
We trade with others because it frees up time and resources to do other things we do _________.
-
We produce what we do _________ best and _________ for the _________.
-
The primary advantages of specialization are that employees acquire greater _________ from repetition, they avoid _________ time in shifting from one task to another, and they do the types of work...
Study smarter with the SolutionInn App