Reference no: EM131337866
Assignment
Instructions: Do not enter anything in the spreadsheet cells that are black, labeled "Grader".
Answer the questions below by placing the appropriate graph and/or answers in the designated cells of the spreadsheet. DO NOT CHANGE THE APPEARANCE OR FUNCTIONALITY OF THE SPREADSHEET
UNLESS INSTRUCTED TO DO SO.
Question
To measure value, Consumer Reports developed a statistic referred as a value score. The value score is based upon five-year owner costs, overall road-test scores, and predicted-reliability ratings. Five-year owner costs are based upon the expenses incurred in the first five years of ownership, including depreciation, fuel, maintenance and repairs, and so on. Using a national average of 12,000 miles per year, an average cost per mile driven is used as the measure of five-year owner costs. Road-test scores are the results of more than 50 tests and evaluations and are based on a 100-point scale, with higher score indicating better performance, comfort, convenience, and fuel economy. The highest road test score obtained in the tests conducted by Consumer Reports was a 99 for a Lexus LS 460L. Predicted reliability ratings
(1=Poor,
2=Fair,
3=Good,
4=Very
Good, and 5=Excellent) are based upon data from Consumer Reports' Annual Auto Survey.
A car with a value score of 1.0 is considered to be an "average value" car. A car with a value Score of 2.0 is considered to be twice as good a value as a car with a value score of 1.0; a Car with a value score of 0.5 is considered half as good as average; and so on.
The data for three sizes of cars (13 small sedans, 20 family sedans, and 21 upscale sedans), Including price ($) of each car tested, are provided in spreadsheet tab labeled Car (Consumer Reports, April, 2012).
a. To incorporate the effect of size of a car, create two dummy variables in Columns H and I using the following coding.
Family-Sedan: 1 if the car is a family sedan and 0 otherwise.
Upscale-Sedan: 1 if the car is an upscale sedan and 0 otherwise.
b. First treating Cost/Mile as the dependent variable, develop an estimated regression with Family-Sedan and Upscale-Sedan as the independent variables. With Cell K3 as the upper left hand corner of the output, fit the full regression model (report Regression Table only). Summarize your model in Cells K12:S20. Are the coefficients significant? Interpret the coefficients.
c. Next treating Value Score as the dependent variable, develop an estimated regression equation using all other variables as the independent variables. Choose Stepwise as the Regression Type. With Cell K26 as the upper left hand corner of the output, fit the full regression model (report Regression Table only). Does your model support the claim that "smaller car provide better values than larger cars?" The Small Sedans represent the smallest type of car and the upscale Sedans represent the largest type of car. State your reasons in Cells K39:S47.
d. Using the model developed in part c, calculated the predicted Value Score in Column J.
Which car has the smallest Value Score residual and which car has the largest Value Score residual?
e. Place the Residual Plot for the model developed in part c in Cells K62:S78. Are the assumptions being satisfied? Is the variance of the error terms constant? Are residuals scattered randomly around zero? Place your assessments in Cells K80:S88 in in the model. Also shade the t stat and p value.
Why should teachers who are already overburdened
: "Why should teachers, who are already overburdened with curriculum requirements, standards of learning, and the daily challenges of caring for young children, take on teacher research?"
|
Federal bankruptcy court protection
: If the Exxon decided to file for federal bankruptcy court protection, what type (chapter) would it probably file and what would be the procedure?
|
Discuss recent developments
: Discuss recent developments (last 10 years) in China's wine market. Also include the potential for growth and the perspective (views) of the Chinese consumers in relation to countries of origin and relative quality of wine.
|
Part of overall growth strategy
: Share your thoughts on past experiences have led Chile to place priority on diversifying its export products as part of overall growth strategy. 200 words
|
Are residuals scattered randomly around zero
: Place the Residual Plot for the model developed in part c in Cells K62:S78. Are the assumptions being satisfied? Is the variance of the error terms constant? Are residuals scattered randomly around zero?
|
Calculate and plot these histories
: If you use more than one method, compare the respective results. Note that, in using FEHT or IHT, a look-up table must be created for prescribing the variation of the heater flux with time (see the appropriate Help section for guidance).
|
Explicit or implicit trade-offs between the perceived value
: Consumers make explicit or implicit trade-offs between the perceived value of a product or service and its cost. Sometimes price is used as a statement of value. Customers seek exchanges giving them the greatest benefits at the lowest costs...most..
|
Describe fundamental principles of behavior
: Why is psychology important? Identify three (3) or more applications of psychology in today's society. (Cite your examples) Describe fundamental principles of behavior and mental functioning, give a detailed explanation
|
Organizational change and employee stress
: Managers need to be able to effectively manage change within organizations in order to mitigate the negative impact of the change on individuals and the organization. In this assignment, you will examine how organizational change causes stress for..
|