Share
Explore BrainMass

Linear Regression

Solve: Linear Regression Modelling

Scenario: A sample of twenty automobiles was taken, and the miles per gallon (MPG), horsepower and total weight were recorded. Develop a linear regression model to predict MPG using horsepower as the only independent variable. Develop another model with weight as the independent variable. Which of these two models is better? Exp

Quantitative Methods: Linear regression,

See attached files. Only questions 4 through 10 are required. Consider the linear regression equation which predicts expenditures on imported goods based on personal disposable income. They are both measured in billions of 1982 dollars. Y'=-261.09+0.2453xt (31.327) (0.0147) to=8.33 and t1=16.616 4. According to

Linear Programming: Kalo Fertilizer, Elixer Drug, Clothier of coats and slacks

See attached file. Four Linear Programming problems: A company produces two products that are processed on two assembly lines. Assembly line 1 has 100 available hours, and assembly line 2 has 42 available hours. Each product requires 10 hrs of processing time on line 1, while on line 2 product 1 requires 7 hours and product

The regression model

A simple linear regression equation, Y=a be, estimated a computer program, produced output: Dependent Variable:S R- Square F-Ratio P-Value On F Observations: 25 0.7482 68.351 0.0001 Variable Parameter Standard Estimate Error T-Ratio

Linear Regression Analysis

Application of simple linear regression analysis to the estimation of a demand equation has yielded the following Q = 24 - 2P If the current product price is P=$6 and the quantity sold per time period is Q = 10, then the erro (e) for the current time period is equal to (actual quantity sold - estimated quantity sold)? 1

Slope

If the t ratio for the slope of a simple linear regression equation is equal to 1.614 and the critical value of the t distribution at the 1% and 5% levels of significance, respectively, are 3.499 and 2.365 is the slope: not significantly different from zero significantly different from zero at both the 1% and 5% levels sign

Simple Regression Analysis

A company is interested in knowing which are the potential sales next year if you use $ 20,000 in advertising expenses. The company uses the information from previous years to make its sales forecast. The data are: Year Sales Advertising $000 $ 000 1 15 2 2 25 3 3 45

0-1 programming model to minimize number of towers required

Problem 11-17 Horizon Wireless, a cellular telephone company, is expanding into a new era. Relay towers are necessary to provide wireless telephone coverage to the different areas of the city. A grid is superimposed on a map of the city to help determine where the towers should be located. The grid consists of 8 areas labeled

Linear Programming and Graphical Method

The Artful Dodger Sports Shop is sponsoring a weekly boomerang throwing contest as part of its spring promotions. Anyone may enter, but the boomerangs uses must be purchased at the The Artful Dodger. Because a smooth finish on the boomerang is essential for accurate flight, most entrants to the contest are expected to buy a new

Regression problems

1. Use the given information to find the P-value. The test statistic in a right-tailed test is z =1.26 P-value =____ (Round to four decimal places as needed) 2. Suppose IQ scores were obtained from randomly selected couples. For 20 such pairs of people, the linear correlation coefficient is 0.904 and the equation of the

Quantitative Methods and Integer Programming Model

The Livewright Medical Supplies Company has a total of 12 salespeople it wants to assign to three regions - the South, the east, and the Midwest. A salesperson in the South earns $600 in profit per month for the company, a salesperson in the Eat earns $540, and a salesperson in the Midwest earns $375. The southern region can hav

Formulate a Linear Program Model with Graphical Analysis

A company produces two products that are processed on two assembly lines. Assembly line 1 has 100 available hours, and assembly line 2 has 42 available hours. Each product requires 10 hours of processing time on line 2, while on line two product 1 requires 7 hours and product 2 requires 3 hours. The profit for line 1 is $6 per u

Use regression to estimate pricing structure

Sales of single family residence increasing in Sin City. This is more pronounced in older communities with cheaper homes, although people are still willing to pay up to live in never communities. Attached spread sheet contains info about location, number of offers made on homes, sq ft of homes, whether home made of brick or no

Total Audience Exposure

Assume Acme Inc. has hired you to be the product manager for their Segways in the Zambia division. Part of your responsibilities is to determine how to promote Segways in Kitwe for the coming month. You have decided that one segment of the promotional campaign will involve purchasing ad time on the four largest radio stations

Linear Regression and Correlation for suburban hotels

A suburban hotel derives its gross income from its hotel and restaurant operations. The owners are interested in the relationship between the number of rooms occupied on a nightly basis and the revenue per day in the restaurant. Below is a sample of 25 days (Monday through Thursday) from last year showing the restaurant income a

Regression and Correlation

2. A college bookstore must order books two months before each semester starts. They believe that the number of books that will ultimately be sold for any particular course is related to the number of students registered for the course when the books are ordered. They would like to develop a linear regression equation to help pl

Bivariate Regression a) Use Excel to make a scatter plot of the data. (b) Select the data points, right-click, select Add Trendline, select the Options tab, and choose Display equation on chart and Display R-squared value on chart. (c) Interpret the fitted slope. (d) Is the intercept meaningful? Explain. (e) Interpret the R2.

(a) Use Excel to make a scatter plot of the data. (b) Select the data points, right-click, select Add Trendline, select the Options tab, and choose Display equation on chart and Display R-squared value on chart. (c) Interpret the fitted slope. (d) Is the intercept meaningful? Explain. (e) Interpret the R2. Moviegoer Spendi

Frobozz: Linear Regression

You are the director of product development for the Frobozz magic thermometer company. You need to determine the markings for the scale printed on the thermometer tube. You take a tube and fill it with mercury, then measure the height of the mercury above a mark near the bottom of the tube at seven different temperatures. You p

Regression hypothesis test for Whitner data set

Using numerical data from the attached data set, develop one research question and formulate a hypothesis which can be tested with linear regression analysis. (Research question is Whether age influences the purchase of domestic or imported vehicles) Perform a regression hypothesis test on the data in the attachments Price Pr

Overdue Bills Case: Linear Regression and Correlation

Quick Stab Collection Agency (QSCA) collects bills in an eastern town. The company specializes in small accounts and avoids risky collections, such as those in which the debtor tends to be chronically late in payments or is known to be hostile. The business can be very profitable. QSCA buys the rights to collect debts from th

Forecasting/Demand Planning

I need some help with Forecasting/Demand Planning. Can you assist me with the following attached information on an excel spreadsheet. Thank you! ----------------------------------------------------------------------------------------------------------------------------------------------- Forecasting/Demand Planning

Graphical Solution Procedure

1. Jake's Country Club would like to determine the best way to allocate a monthly advertising budget of $1000 between newspaper advertising and radio advertising. Management decided that at least 25% of the budget must be spent on each type of media, and that the amount of money spent on local newspaper advertising must be at le

Linear Programming Applications

Linear Programming Applications: The Two-Rivers Oil Company near Pittsburg transports gasoline to its distributors by truck. The company recently contracted to supply gasoline distributors in southern Ohio, and it has $600,000 available to spend on the necessary expansion of its fleet of gasoline tank trucks. Three models of

Linear Regression, Trends and Forecasting

The amounts spent in vending machines in the united states, in billions of dollars, for the years 1999 through 2003 are given below. Determine the least squares trend equation, and estimate vending sales for 2005. Year code vending machine sales 1999 1 17.5 2000 2 19.0

Calculations for Simple Linear Regression Analysis

For the y and x values listed, obtain the simple linear regression equation, then analyze the residuals by: a. constructing a histogram b. using a normal probability c. plotting the residuals versus the x values d. plotting the residuals versus the order which they were observed. Do any of the assumptions of the si

Regression Analysis Paper Scatter Plot

The U.S. Congress enacted legislation in 2005 authorizing Block Grants to cities as part of an Anti-Crime initiative. The grant monies are to be used to hire additional police officers for conducting beat patrols in high crime areas. As part of the determination for how much money to grant, nine cities in New Jersey were part of

Linear Programming Model

Please provide solution in EXCEL format. PRODUCTION. Minnesota Fabrics produces three sizes of comforters (full, queen, and king size) that it markets to major retail establishments throughout the country. Due to contracts with these establishments, Minnesota Fabrics must produce at least 120 of each size comforter daily.

Linear Programming Model

Compaids, Inc. manufacturers two types of slide-out keyboard trays for use with personal computers. Model C15 is designed for desktop use. It can stand alone, or it can fit under a desktop CPU or monitor. Model UN8 is designed to be mounted underneath a desk with screws. Both units are manufactured from laminated particle bo