Cost-of-living indices are often used to measure the desirability of living in a particular geographical area. The
Question:
Cost-of-living indices are often used to measure the desirability of living in a particular geographical area. The data in the following table give a composite index and six component indices for several urban areas in the United States.
a. Build a linear model to predict the composite index based on the component indices. Evaluate the model in terms of overall goodness-of-fit. Evaluate the results for each regression parameter: Are the signs appropriate? Are the values different from zero?
b. Can you improve the model in (a) by removing or transforming one or more of the explanatory variables from the regression? If so, compare the advantages and disadvantages of the resulting regression to the one in (a).
Urban area Birmingham, AL Cullman County, AL Decatur-Hartselle, AL Gasden, AL Huntsville, AL Marshall County, AL Mobile, AL Montgomery, AL Anchorage, AK Fairbanks, AK Juneau, AK Composite index 98.4 95.0 94.7 93.2 95.6 91.2 96.0 100.8 123.0 128.7 140.0 Grocery items 97.7 98.9 95.8 101.5 94.1 101.5 100.5 98.5 120.1 118.4 122.6 Housing Utilities Transportation 94.8 95.5 88.1 97.4 87.4 102.2 79.1 87.0 85.1 101.9 84.6 82.0 94.9 132.3 134.0 164.2 102.6 98.7 89.8 101.8 88.6 97.6 105.2 102.0 88.0 166.7 157.2 87.3 102.6 99.3 112.0 119.6 117.2 Health care 98.3 87.1 96.3 87.4 99.3 83.1 91.1 94.1 170.1 168.1 165.5 Miscellaneous goods and services 101.5 98.9 99.3 101.7 104.6 92.9 102.6 108.3 119.3 115.3 125.2
Step by Step Answer:
Solution a The linear model for this data is Using the Compute Fit command in the RegressionOLS modu...View the full answer
Management Science The Art Of Modeling With Spreadsheets
ISBN: 9780470530672
3rd Edition
Authors: Stephen G. Powell, Kenneth R. Baker
Students also viewed these Business questions
-
In nuclear physics, detectors are often used to measure the energy of a particle. To calibrate a detector, particles of known energy are directed into it. The values of signals from 15 different...
-
The Michelson interferometer can be used to measure the index of refraction of a gas by placing an evacuated transparent tube in the light path along one arm of the device. Fringe shifts occur as the...
-
A photocell is a device used to measure the intensity of light. In a certain experiment, when light of wavelength 630 nm is directed onto the photocell, electrons are emitted at the rate of 2.6 x...
-
Implement a generic Map that supports the put and get operations. The implementation will store a hash table of pairs (key, definition). Figure 5.55 provides the Map specification (minus some...
-
Suppose that X1, . . . , Xn form a random sample from the normal distribution with unknown mean and known variance 2. Suppose also that the prior distribution of is normal with mean and variance...
-
James Morgan is an entrepreneur who established an IT software business in cloud computing named Arista Networks Ltd (Arista Networks) in West Perth, Western Australia. Arista Networks daily...
-
Suppose that in September 2013 a company takes a long position in a contract on May 2014 crude oil futures. It closes out its position in March 2014. The futures price (per barrel) is \($88.30\) when...
-
Simmons Corporation owns stock of Armstrong, Inc prior to 2010 the investment was accounted for using the equity method. In early 2010, Simmons sold part of its investment in Armstrong, and began...
-
An object moved on the xaxis from point A to point B, turned around and moved to point C in 2 seconds. Assume direction towards the right as the positive direction. The coordinates of A, B, and C are...
-
Linkin Corporation is considering purchasing a new delivery truck. The truck has many advantages over the company's current truck (not the least of which is that it runs). The new truck would cost...
-
Cost Modeling. General Widget Corporation has collected data on the daily output and daily production cost of widgets produced at its factory. (Data for the study are shown in the table below.) The...
-
A commission on state parks is interested in identifying the factors that determine park revenues. Data are available at the state level on total revenues, acreage, number of day visitors, number of...
-
The example of a silyl-Hilbert-Johnson nucleosidation reaction in Section 25.3 is presumed to involve an intermediate ribosyl cation that is stabilized by intramolecular interactions involving the C2...
-
Peter is an international student currently studying a Master of Professional Accounting degree at TIIS Sydney commencing July 2022. Evaluate whether he is a tax resident of Australia for tax...
-
Use the following information on the economic balance sheet of a bank: Assets ($ million) Cash 20 Liabilities and equity (S million) Demand deposits Interbank deposits 50 Term deposits Loans 200...
-
How can we use tools of digital marketing such as content marketing, SEO, social media marketing, PPC, display advertising, affiliate marketing and email marketing to advance our brand?
-
Phoenix Electronics Inc is evaluating a microprocessor investment. The company's management team rec- ognizes the superiority of the NPV technique, but like the presentational advantages of IRR (for...
-
2. Answer the following questions using Figure 1 (2.5 points each; 15 points total) Figure 1 one individual O-disease dropout Jan 1 Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 31 Assumptions: Each...
-
Fresh water is obtained from seawater at a rate of 1.5m3/s by a desalination plant that consumes 11.5 MW of power and has a second-law efficiency of 20 percent. Determine the power that can be...
-
Doorharmony Company makes doorbells. It has a weighted- average cost of capital of 5% and total assets of $ 5,900,000. Doorharmony has current liabilities of $ 750,000. Its operating income for the...
-
a. The population figures will show that there are 3,000 children, 2,500 teenagers, 500 seniors, and 9,000 other adults in the population. If there were no stock on hand, what amount would be...
-
Refer to the Reid's Raisins case. From the corresponding exercise in Chapter 3, review the design of a spreadsheet that will allow the firm to determine how many grapes to buy under contract and how...
-
a. What is the Net Present Value of the firm's cash flows over the five-year period? b. Construct a tornado chart for the analysis in (a). List the relevant parameters in descending order of their...
-
I need ILAC ( ISSUE , LAW, APPLICATION, CONCLUSION ) for this : ISSUE: Enforceability of the shareholders' resolution to receive a weekly sum for each week that their dividend is outstanding. Under...
-
help me incorporate my 3 main topics into this summary of my essay. My topics are 1.) How the charter protects protects human rights, 2.) What is the charter of rights and freedom and 3.) Why it's...
-
What is a longarm statute? What is an unlimited longarm statute? What part of the U.S. Constitution is the focus of the modern interpretation of personal jurisdiction? What are the elements of level...
Study smarter with the SolutionInn App