Purchase Solution

Develop a linear equation that can be used to describe how the price depends on the processor speed.

Not what you're looking for?

Ask Custom Question

My workgroup wants to move from desktop to laptop computers so that we can work remotely without having to access our network from "foreign"computers, which is greatly frowned upon. Because we don't have an actual budget for the purchase of the laptops, we would like to present research showing justification for the type of laptop we choose. Based on past experience, we prefer Dell products, but would like to also consider HP/Compaq, Sony Vaio and Toshiba. Like all users though, we have a "need for speed." Therefore, we have decided to research the aforementioned brands for price compared to processing speed. Our goal is to determine which laptops are over/under-priced based on processing speed and use this information to in our presentation to management.

The following data shows the retail price for 12 randomly selected laptop computers along with their corresponding processor speeds.
Laptop Price Speed
Dell Inspiron 1501 $599 1.80
Dell Inspiron 1405 $749 1.66
Dell Inspiron 1505 $749 2.16
Dell XPS M1210 $1,299 2.00
Dell XPS M1710 $2,299 2.00
Dell XPS M2010 $2,999 2.00
HP Compaq nc8430 $1,399 1.83
HP Compaq nw8440 $1,999 1.83
HP Compaq nc2400 $1,549 1.06
Sony Vaio VGN-FE880E/H $1,300 1.66
Toshiba Satellite A135-S2246 $650 1.73
Portege R400-S4831 $2,495.04 2.00

a. Develop a linear equation that can be used to describe how the price depends on the processor speed.
b. Based on your regression equation, is there one machine that seems particularly over- or underpriced?
c. Compute the correlation coefficient between the two variables. At the .05 significance level conduct a test of hypothesis to determine if the population correlation could be greater than zero.
d. draw a box plot reflecting how the price depends on the processor speed.

Attachments
Purchase this Solution
Solution Summary

Excel regression and document attached assist you in interpreting and reporting the regression results.

Solution Preview

Please see the attached file.

The r-square for the regression is 0.043, which is ...

Purchase this Solution
Free BrainMass Quizzes
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.

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.

View More Free Quizzes
Related BrainMass Solutions

  • Linear Regression: Developing Equations

    Develop a linear equation that can be used to describe how the price depends on the processor speed. b. Based on your regression equation, is there one machine that seems particularly over- or underpriced? c.

  • Regression Analysis and Hypothesis Test

    Develop a linear equation that can be used to describe how the price depends on the processor speed. b. Based on your regression equation, is there one machine that seems particularly over or under-priced? c.

  • Linear equations for price and processor speed

    Develop a linear equation that can be used to describe how the price depends on the processor speed. B. Based on your regression equation, is there one machine that seems particularly over-or-underpriced. C.

  • Descriptive Statistics & Regression Analysis

    Develop a linear equation that can be used to describe how the price depends on the processor speed. b. Based on your regression equation, is there one machine that seems particularly over- or underpriced? c.

  • Regression Analysis and Correlation Hypothesis Test

    Develop a linear equation that can be used to describe how the price depends on the processor speed. B. Based on your regression equation is there one machine that seems particularly over-or-underpriced? C.

  • Regression analysis and hypothes testing

    Develop a linear equation that can be used to describe how the price depends on the processor speed. E b. Based on your regression equation, is there one machine that seems particularly over or under priced? c.

  • Equilibrium price and equilibrium quantity using linear functions

    That is, the price your supplier charges you depends on the quantity you buy from them. The price you charge your customers depends on the level of demand they have for your product. Let p := price, q := quantity.

  • Regression Analysis - Using PHStat or Excel

    613800 Regression Analysis - Using PHStat or Excel [1] A research analyst for an oil company wants to develop a model to predict miles per gallon based on highway speed.

  • Correlation and Regression Analysis

    Develop an estimated regression equation that can be used to predict annual sales given the years of experience. c. Use the estimated regression equation to predict annual sales for a salesperson with nine years of experience. 17.

View More Related Solutions