Reference no: EM131092802
1. A developer who specializes in summer cottage property is considering purchasing a large tract of land adjoining a lake. The current owner of the tract has already subdivided the land into separate building lots and has prepared the lots by removing some of the trees. The Developer wants to forecast the value of each lot. From previous experience, she knows that the most important factors affecting the price of the lot are size (lot size), number of mature trees (Trees), and distance to the lake (Distance). From a nearby area, she gathers data for 60 recently sold lots. These data are stored in Devloper.xls.
(a) Perform a multiple regression in Excel and provide excel output for the regression model = βo + βo(Lot size) + βo(Trees) + βo(Distance) + ∈
(b) Write down the equation for regression line.
(c) What is the standard error of estimate? Interpret its value.
(d) What is the coefficient of determination? What does this statistic tell you?
(e) What is the coefficient of determination, adjusted for degrees of freedom? Why does this value differ from the coefficient of determination? What does this tell you about the model?
(f) Test the overall utility of the model. What does the p-value of the test statistic tell you?
(g) Interpret each of the coefficients.
(h) Test to determine whether each of the independent variables is linearly related to the price of the lot.
2. The marketing manager for a chain of hardware stores needs more information about the effectiveness of the three types of advertising that the chain uses. These are (i) localised direct mailing (in which flyers describing sales and product features are distributed to homes in the surrounding area), (ii) newspaper advertising and (iii) local television advertising. To determine which type of advertising is most effective, the manager collects one week's data from 100 randomly selected stores. For each store, the following variables are recorded:
Weekly gross sales
Weekly expenditures on direct mailing
Weekly expenditures on newspaper advertising Weekly expenditures on television commercials
All variables are recorded in thousands of dollars and stored in columns 1 to 4, respectively, in file GrossSales.xls.
a. Find and write out the regression line.
b. What is the Coefficient of Determination? What is the Coefficient of Determination adjusted for degrees of freedom? What do these statistics tell you about the regression model? Using the ANOVA table, calculate R2, the Adjusted R2 and the standard error of the estimate, Sε. Confirm that these values are the same as those shown in the computer output.
c. What does the standard error of the estimate tell you about the regression model (compare with the mean weekly gross sales, which you will need to compute)?
d. Test the overall utility of the model using an F-Test. What does the p-value of this test tell you?
|
Describe in detail the use of microfluidics in one agilent
: Describe in detail the use of microfluidics in one Agilent analyzer. Discuss the types of determinations possible and the advantages and limitations of lab-on-a-chip technology as applied to the analyzer chosen.
|
|
What is span of control
: When designing a company's personnel infrastructure, in addition to segregation of duties, it is considered by many reasonable to consider 1. span of control, and 2.critical access as two of the principles to be used to combat fraud.
|
|
Understand the definition of np
: Remarks: For this question, it is important to understand the definition of NP, and the definitions of some of the standard NP-complete problems (Vertex Cover, Set Cover, Independent Set, Hamiltonian Path, etc.)
|
|
Separate stem-and-leaf plots for the number of cases
: Grocery retailer. A large, national grocery retailer tracks productivity and costs of its facilities closely. Data below were obtained from a single distribution center for a one-year period.
|
|
Write down the equation for regression line
: GB513 - Multiple Linear Regression Write down the equation for regression line - What is the standard error of estimate? Interpret its value and what is the coefficient of determination?
|
|
Describe how added sugars can contribute to health problems
: Identify the health benefits of, and recommendations for, starches and fibers. Be specific and name health problems associated with the intake of starches and fibers.
|
|
Scatter plot matrix and the correction matrix
: Brand preference. In ,l small-scale experimental study of the relation between degree of brand liking (Y) and moisture content (XI) and sweetness (X2 ) of the product, the following results were obtained from the experiment based on a completely ..
|
|
Wireless and mobile technologies
: In this very competitive climate, many companies are seeking ways to connect with customers in ways that add value. Mobile and wireless computing have become key focal points to attract and retain customers.
|
|
Contrast continuous flow and discrete automated systems
: Give the advantages and disadvantages of each type of automated system.
|