Share
Explore BrainMass

Linear Regression

Linear Regression Hypothesis Analysis for Real Estate Data Set

See attached data file. Using the attached Excel numerical data, develop a research question, formulate a hypothesis, and perform a linear regression analysis and hypothesis test on the data. Include raw data tables and the results of computations, using both graphical and tabular methods of displaying data and results.

Regression - GPA and StartSal

A university has studied the relationship between the GPA (grade point average) of its graduates and StartSal, their starting salaries (in thousands of dollars). A sample of seven graduates was randomly selected. The data collected and output from Excel are shown below: MKTGrad GPA

20 Business Statistics Questions

Please see attached file to view the tables. 1. The Y-intercept (b0) represents the A) variation around the sample regression line. B) predicted value of Y when X = 0. C) predicted value of Y. D) change in estimated average Y per unit change in X. 2. The slope (b1) represents the A) predicted value of Y when X =

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

Correalation and Regression

Construct a scatterplot of the raw data. Then, run the correlation/regression program. Commuters and Parking Spaces: Listed below are the numbers of commuters and the number pf parking spaces at different Metro - North railroad stations. Is there a linear correlation between the number of commuters and the number of parking

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

Linear Programming Model to Maximize Profit for a Glassblower

A glassblower makes glass decanters and glass trays on a weekly basic. Each item require 1 pound of glass, and the glassblower has 15 pounds of glass available each week. A glass decanter requires 4 hours of labor, a glass tray requires only 1 hour of labor, and the glassblower works 25 hours a week. The profit from a decanter i

Non Linear Regression: exponential trend curve

1. For each company, fit an exponential trend curve to their sales data. 2. For which company does exponential growth have the best fit to revenue growth? 3. For which company does exponential growth have the worst fit to revenue growth? 4. For each company, estimate the annual percentage growth rate for revenues

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