Purchase Solution

Multiple Regression Problem: Mail-order catalogue business.

Not what you're looking for?

Ask Custom Question

A mail-order catalog business maintains a warehouse for distribution of products ordered. Management is currently investigating what factors affect distribution costs. Data has been collected for the past 24 months indicating warehouse distribution costs, sales, numbers of orders and average order processing time. See the Excel file containing the data. Assignment 7 part A data.xlsx.
1. Using the data below, perform regression analysis to determine how the three variables affect distribution costs. Show the final model and the work needed to reach this result. Use Alpha = 0.1.
2. Interpret the coefficients of the variables in the final model.
3. Why don't the coefficients in this problem (and regression problems in general) indicate the amount of influence each variable has?
4. Indicate the strength of relationship for the final model and interpret its value.
5. Given Sales of $475,000, number of orders of $4000, average processing time of 25 minutes, calculate distribution costs and interpret the numerical value.

Attachments
Purchase this Solution
Solution Summary

This solution is comprised of a detailed explanation the multiple regression problem with the help of excel. All the answers for 5 questions are given. In this solution, step-by-step explanation of this complicated topic provides students with a clear explanation.

Purchase this Solution
Free BrainMass Quizzes
Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

View More Free Quizzes
Related BrainMass Solutions

  • Statistics: factors in the process of distribution

    Problem 13.16 In problem 13.5 (above), sales and number of orders were used to predict distribution costs at a mail order catalog business. Using the computer output you obtained to solve that problem: a.

  • BEASTBUY Data Analysis

    444420 Help with ANOVA and linear and multiple regression I need help with the following type of problem: You work in the shipping and logistics department for Beast Buy, an American mail order company that specializes in pet food for VERY exotic pets

  • Case study solution with the help of statistical techniques

    Problem 4.3 Here, your task is to combine 4.1 and 4.2 into a single multiple regression model using dummy variables.

  • competitive advantage of e-business

    The use of e-mail rather than "snail-mail" allowing for immediate feedback from customers and deemed a more effective means of communication medium.

  • Please Provide Answers steps by steps. Thanks!

    b) Assuming a linear relationship, find the regression coefficients, b0, b1, and its regression equation. c) Interpret the meaning of the slope b1 in this problem.

  • Outsourcing the catalogue production

    332961 Arctic Clothing is considering outsourcing the catalogue production. Compare options Arctic Clothing has operated a direct-mail clothing business specializing in outdoor adventure clothing for more than 15 years.

  • Marketing - Multichannel Marketing is the wave of the future in business.

    JC penny is also a merchant where you can visit the store, but in this case, there are 2 more channels to purchase items - online and through a catalogue, where they mail you your merchandise when you place an order over the phone.

  • ANOVA & Regression Analysis for Beast Buy

    416604 ANOVA & Regression Analysis for Beast Buy You work in the shipping and logistics department for Beast Buy, an American mail order company that specializes in pet food for VERY exotic pets.

  • Regression - Beast Buy

    356804 Best Buy Problem Set 4 Introduction You work in the shipping and logistics department for Beast Buy, an American mail order company that specializes in pet food for VERY exotic pets.

View More Related Solutions