0% found this document useful (0 votes)
30 views4 pages

Regression Analysis in Cost Estimation

The document provides 10 assignments analyzing various datasets using statistical and regression analysis techniques. The assignments involve analyzing relationships between variables, identifying outliers, computing correlations, developing regression models, interpreting results, and making predictions based on the analyses. Key goals are to understand relationships between variables and how well variables predict each other.

Uploaded by

Bhushan Shirsath
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
30 views4 pages

Regression Analysis in Cost Estimation

The document provides 10 assignments analyzing various datasets using statistical and regression analysis techniques. The assignments involve analyzing relationships between variables, identifying outliers, computing correlations, developing regression models, interpreting results, and making predictions based on the analyses. Key goals are to understand relationships between variables and how well variables predict each other.

Uploaded by

Bhushan Shirsath
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

104.

BUSINESS STATISTICS : ASSIGNMENT - 2

A1 (21101-107)

The data describe housing prices in the Philadelphia area. Each of the 110 rows of this data
table describes a region of the metropolitan area. (Several make up the city of Philadelphia).
One column, labeled Selling Price, gives the median price for homes sold in that area during
1999 in thousands of dollars. Another labeled Crime Rate, gives the number of crimes
committed in that area, per 1,00,000 residents. [[Link]]

a. Make a scatter plot of the selling price on the crime rate. Which observation stands
out from the others? Is this outlier unusual in terms of either marginal distribution?
b. Find the correlation using all of the data as shown in the prior scatter plot.
c. Exclude the distinct outlier and redraw the scatter plot focused on rest of the data.
Does your impression of the relationship between the crime rate and selling price
change?
d. Compute the correlation without the outlier. Does it change much?
e. Can we conclude from the correlation that crimes in the Philadelphia area cause a rise
or fall in the value of real estate?

A2 (21108-114)

The owner of Showtime Movie Theatres Inc. would like to estimate weekly gross revenue as
a function of advertising expenditures. Historical data for a sample of eight weeks is given in
[[Link]]

a. Develop an estimated regression equation with the amount of television adverting as


an independent variable.
b. Develop an estimated regression equation with both television advertising and
newspaper advertising as the independent variables.
c. Is the estimated regression equation coefficient for the television advertising
expenditures the same in part (a) and part (b). Interpret the coefficient in each case.
d. What is the estimate of the weekly gross revenue for a week when $3500 is spent on
television advertising and $1800 is spent on newspaper advertising?
e. Draw the scatter plot with the amount of newspaper adverting as an independent
variable and weekly gross revenue as the dependent variable.

A3 (21115-121)

[[Link]] : These data give the times in minutes for the 140 cyclist who competed
in 2006 Tour de France and raced in both time trial events. In a time trial, each cyclist
individually rides a set course. The rider with the shortest time wins the event. The courses in
the 2006 tour were each about 35 miles long. (Stage 7 was of 52 km long and stage 19 was 57
km long)
a. Would you expect the times to be associated?
b. Make a scatter plot for these data, with the first set of times (from Stage 7) along the
x-axis. Do the variables appear to be associated? Describe the relationship, if any.
c. Find the correlation between these variables, if appropriate.
d. Identify the times for Floyd Landis in the scatter plot. Did he perform as well in the
second race, with the championship on the line, as in the first race?

A4 (21122-128)

For the data in [[Link]]

a. Make a scatter plot of weight & highway mileage. Which variable do you think makes
the most sense to put on the x-axis and which belongs on the y-axis?
b. Describe any pattern that you see in the plot. Be sure to identify any outliers.
c. Find the correlation between these two variables.
d. Interpret the correlation in the context of these data. Does the correlation provide a
good summary of the strength of the relationship?
e. Describe the marginal distribution of MPG Highway and Weight. Include the mean &
SD of both variables.
f. Use the correlation line to estimate the mileage of a car that weighs 4000 pounds.
Does this seem like a sensible procedure?

A5 (21129-135)

An economist wishes to predict the market value of owner-occupied homes in small mid-
western cities. She has collected a set of data from 45 small cities for a 2-year period and
wants you to use this as the data source for the analysis. She wants you to develop two
prediction equations: one that uses the size of the house as a predictor and a second that uses
the tax rate as a predictor. [[Link]]

a. Plot the market value of houses (hseval) versus the size of houses (sizehse), and then
versus the tax rates (taxrate). Note any unusual patterns in the data.
b. Prepare regression analyses for the two predictor variables. Which variable is the
stronger predictor of the value of houses?
c. A business developer in a mid-western state has stated that local property tax rates in
small towns need to be lowered because if they are not, no one will purchase a house
in these towns. Based on your analysis in this problem, evaluate the business
developer’s claim.
A6 (21136-142)

The following table [[Link]] reports the horsepower, curb weight and the speed at ¼ mile
for 16 sports and GT cars (1998 Road& Track Sports & GT Cars)

a. Use curb weight as the independent variable and the speed at ¼ mile as the dependent
variable and draw the scatter plot.
b. Find the correlation between these two variables and interpret it in the context of these
data. Does the correlation provide a good summary of the strength of the relationship?
c. What is the estimated regression equation?
d. Use curb weight and horsepower as two independent variables and the speed at ¼
miles as he dependent variable. What is the estimated regression equation?
e. The 1999 Porsche 911 Carrera has been advertised as having a curb weight of 2990
pounds and an engine with 296 horsepower. Use the results in (d) to predict the speed
at ¼ mile for the Porsche 911.

A7 (21143-149)

[[Link]] :

The temperature in December in Buffalo, New York is often below 40 degrees Fahrenheit (4
degrees Celsius). Not surprisingly when National Football League Buffalo Bills play at home
in December, coffee is a popular item at the concession stand. The Concession manager
would like to acquire more information so that he can manage inventories more efficiently.
The numbers of cups of coffee sold during 50 games played in December in Buffalo were
recorded. Suppose that in addition to recording the coffee sales, the manager also recorded
average temperature (measured in degrees Fahrenheit) during the game. These data together
with the number of cups of coffee sold were recorded

a. Compute the coefficient of determination


b. Determine the coefficient of least squares line
c. What have you learned from statistics calculated in Parts (a and b above) about the
relationship between the number of cups of coffee sold and the temperature?
d. If the temperature forecast for the next week’s game time is 30 degrees Fahrenheit,
how much coffee sales can the manager expect to make?

A8 (21150-156)

If the airline flight that you are on is 20 minutes late departing, can you expect the pilot to
make these minutes by, say, flying faster than usual? These data summaries the status of a
sample of 984 flights during 2006.(Bureau of Transportation Statistics). [[Link]]

a. Do you expect the number of minutes that the flight is delayed departing to be
associated with the arrival delay?
b. Make a scatter plot of the arrival delay (in minutes) on the departure delay (also in
minutes). Summarize the association present in the scatter plot, if any?
c. Find the correlation between arrival delay and departure delay and interpret the result.
d. How is the correlation affected by the evident outlier, a flight with very strong delays?
e. How would the correlation change if delays were measured in hours rather than
minutes?

A9 (21157-163)

An important application of regression analysis in accounting is in the estimation of cost. By


collecting data on volume and cost and using the least squares method to develop an
estimated regression equation relating volume and cost, an accountant can estimate the cost
associated with a particular manufacturing volume. Consider the following sample of
production volumes and total cost data for a manufacturing operation

Production Volume (units) Total Cost (Rs)


400 4000
450 5000
550 5400
600 5900
700 6400
750 7000
a. Develop a scatter diagram for these data with Production volume as an independent
variable. What does it indicate about the relationship between Production volume and
Total cost?
b. Use this data to develop an estimated regression equation that could be used to predict
the total cost for a given production volume.
c. What is the variable cost per unit produced
d. What percentage of the variation in total cost can be explained by production volume?
e. The company’s production schedule shows 500 units must be produced next month.
What is the estimated total cost for this operation?

A10 (21164-171)

The table in [ForFunds] gives the annual return, the safety rating (0 = riskiest, 10= safest)
and the annual expense ratio for 20 foreign funds (Mutual Fund, March2000)

a. Use annual expense ratio as the independent variable and the annual return as the
dependent variable to draw the scatter plot. Compute the coefficient of determination
and describe what it tells you.
b. What is the estimated regression equation?
c. Develop an estimated regression equation relating the annual return to the safety
rating and the annual expense ratio
d. Estimate the annual return for a firm that has a safety rating of 7.5 and annual expense
ratio of 2.

Common questions

Powered by AI

A regression model utilizing curb weight and horsepower can effectively predict the quarter-mile speed of the Porsche 911 Carrera by quantifying the influence each factor has on velocity. These variables are critical indicators of automotive performance. However, the prediction's accuracy might be limited by potential omitted variables such as aerodynamics or tire grip, which also significantly influence vehicle performance, and the fit of the model to the specific characteristics of the car .

The weight of a car inversely relates to its highway mileage. Heavier cars typically have lower mileage due to increased fuel consumption. This established relationship implies that when estimating the fuel efficiency of cars, considering their weight is crucial. Therefore, using weight as a predictor can enhance the accuracy of fuel efficiency predictions, although assessing the full contextual factors, like engine efficiency, is also necessary .

Including newspaper advertising alongside television advertising in the regression model typically provides a more comprehensive understanding of the factors affecting weekly gross revenue. The coefficient for television advertising might change, reflecting its distinct contribution from that of newspaper advertising. This helps to better isolate the effect of each type of advertising, potentially leading to a more accurate and holistic estimate of gross revenue .

Annual expense ratios and safety ratings jointly influence the annual return of foreign funds by indicating costs and risk levels, respectively. Lower expense ratios often increase net returns, whereas higher safety ratings imply lower risk and potentially lower returns. Financial managers can utilize these insights for crafting portfolios that balance risk tolerance with return expectations, optimizing both cost efficiency and risk management strategies in investment planning .

Using volume as a predictor for manufacturing costs implies that production volume is a significant driver of costs, embodying variable costs. The coefficient of determination quantifies how well production volume accounts for cost variability. A high coefficient suggests that volume changes are strongly indicative of cost changes, providing manufacturers crucial insights into cost management and potential efficiency improvements .

Excluding an outlier decreases the correlation between crime rate and housing prices. The initial correlation includes all data points which might show a certain level of association between the crime rate and housing prices. However, once the outlier is removed, the correlation might change significantly, suggesting that the outlier had a substantial influence on the initial correlation value. This implies that the relationship observed might have been largely affected by an unusual data point, rather than a consistent trend across the data set .

The tax rate can significantly influence the real estate market value of houses in small cities, often serving as an expense that reduces purchasing power and attractiveness of a location. If the regression analysis shows a strong predictive relationship, it suggests that higher tax rates could lower housing market values, supporting claims that reducing tax rates might boost property investments. This finding is significant for local policymakers who seek to balance tax revenue with promoting economic growth through home ownership incentives .

The times for the two time trial stages in the 2006 Tour de France are expected to be strongly correlated, as cyclists' performances should be relatively consistent across similar events. A high correlation between these times indicates that cyclists tend to perform similarly across the stages, which suggests performance consistency. For example, identifying the performance of Floyd Landis across stages can further highlight individual consistency or variance in performance under different conditions .

The correlation coefficient between arrival and departure delays reflects the degree to which delays propagate through airline schedules. A high correlation implies that delay in departures tends to result in similarly delayed arrivals, indicating a systemic scheduling challenge where recovering lost time during the flight is difficult. Thus, it suggests a need for better buffer times or operational efficiencies to minimize cascading delays .

Temperature inversely affects coffee sales during football games in Buffalo; as temperature decreases, coffee sales increase. The predictive model enables the concession manager to forecast demand based on temperature predictions, thus optimizing inventory. Understanding this relationship allows for efficient resource management and reduced wastage, adjusting inventory in anticipation of cooler temperatures to maximize sales opportunities .

You might also like