Advantages of Linear Regression in Complex Situations
How does a linear regression allow us to better estimate trends, costs, and other factors in complex situations?
How does a linear regression allow us to better estimate trends, costs, and other factors in complex situations?
Tessmer Manufacturing Company produces inventory in a highly automated assembly plant in Olathe, Kansas. The automated system is in its first year of operation and management is still unsure of the best way to estimate the overhead costs of operations for budgetary purposes. For the first six months of operations, the following
See attached data files. Engineering Salaries Analysis for an MS A project requires us to develop a regression model to assist us in our salary/bonus prediction based on variables represented by analyzing various factors about each engineering school. For example: (1) if a student wants to go to a specific engineeri
See data file attached. The manager of the purchasing department of a large banking organization would like to develop a model to predict the amount of time it takes to process invoices. Data are collected from a sample of 30 days, and the number of invoices processed and completion time, in hours, is stored in the file invoi
See the attached file. (1) What can you now infer about the relationship between Corporate Taxes and Capital Formation (Investment)? Is it a positive or negative relationship? (based on the attached Case study) (2) Based on the attached lecture, look at the original table....it is a snapshot of the world economy from the
See data file attached. The manager of the purchasing department of a large banking organization would like to develop a model to predict the amount of time it takes to process invoices. Data are collected from a sample of 30 days, and the number of invoices processed and completion time, in hours, is stored in the file invoi
1. An auto manufacturing company wanted to investigate how the price of one of its car models depreciates with age. The research department at the company took a sample of eight cars of this model and collected the following information on the ages (in years) and prices (in hundreds of dollars) of these cars. Age (x) 8 3 6 9
Caseload per worker for each of the past 48 months is shown in the attached Excel file, as well as the number of workers budgeted and the numbers of workers who actually reported to work during each month. The caseload changes periodically, mainly down in the summer, up in the fall, down in winter, up in the spring. I need
See attached files. Prepare a report using Excel as your processing tool to process three simple regression analyses. 1. First run a regression analysis using the BENEFITS column of all data points in the AIU data set as the independent variable and the INTRINSIC job satisfaction column of all data points in the AIU data
See attached data as an excel spread sheet. INFORMATION 14 The data in DJIA.XLS (CD-> browse->Excel_Data_Files) represent the closing value of the Dow Jones Industrial Average (DJIA) over the 27-year period 1979 through 2005. See Problem 16.29 (p.675). Using EXCEL or PHStat2, answer the following: 1. When fitting a thir
Does the price of homes depend on the distance from the city centre? Perform a five-step hypothesis test on the given research question.
A large consumer product company wants to measure the effectiveness of different types of advertising media in the promotion of its products. Specifically, two types of advertising media are to be considered: radio/TV advertising and newspaper advertising (including the cost of discount coupons). The sales of product (in thousan
See attached files. Attached is the article I chose for the report (PDF File). If the article does not have the information required to complete the ANOVA process, there is an excel file ("Data Set and Data Key") that has data to complete this process (this is referenced in the "project" portion of the message below as the AI
A logistic regression model was used to assess the association between CVD and obesity. P is defined to be the probability that the people have CVD. log(P/(1-P)) = -2 + 0.7(obesity) What is the odds ratio for CVD in persons who are obese as compared to not obese?
Problems 1, 3 1. Use the graph below to describe the total variation about a regression line in words and in symbols. This is the answer from the book, but how? S(yi - y)2; the sum of the squares of the differences between the y-values of each ordered pair and the mean of the y-values of the ordered pairs. 3 Use the
Philip Morris Versus the Market. The table (see Minitab attachment) shows the monthly returns on the common stock of Philip Morris (MO), as the company was then named, and the returns on the Standard & Poor's 500 stock index for the same months. Return is measured in percent. The data are for 83 consecutive months running from
See data file attached. A brokerage house wants to predict the number of trade executions per day, using the number of incoming phone calls as a predictor variable. Data were collected over a period of 35 days and are stored in the file trades.xls. a. Use the least-squares method to compute the regression coefficients b0
For the following data: a) find the regression equation for the predicting y from x. b) use the regression equation to find a predicted y for each x c) find the difference between the actual y value and the predicted y value for each individual, square the differences and add the squared values to obtain ss residual. d) calc
A set of n=20 pairs of score (x and y values) has ssx=25, ssy=16, and sp=12.5. If the mean for the x values is m=6 and the mean for the y values is m=4. a) Calculate the Pearson Correlation for the scores. b) Find the regression equation for predicting y from the x values.
A psychologist studying perceived 'quality of life' in a large number of cities (N=150) came up with the following equation using mean temperature (Temp), median income in $1000 (Income), per capita expenditure on social services (SocSer), and population density (Popul) as predictors. Y= 5.37-0.01Temp+ 0.05Income + 0.003SocSe
Select the appropriate statistical test that allows you to conduct an analysis of the factors affecting hospital costs. You will have to select the correct statistical test and conduct that test in Excel. 1. Analyze your data and produce a summary describing the major findings of your analysis. 2. The variables that most
Accu-Copiers, Inc. sells and services the Accu-500 copying machine. As part of its standard service contract, the company agrees to perform routine service on this copier. To obtain information about the time it takes to perform routine service, Accu-Copiers has collected data for 11 service calls. The service calls information
In business, investors are always interested in the tradeoff between returns and risk. Regression analysis is a statistical technique that can be used to quantify this risk. Explain the concept of dependent and independent variables in terms of a business performance indicator e.g. stock price, profits, etc., clearly stating th
The U.S. Navy selected 16 hospitals that it believes to be efficiently run and conducted a regression analysis to evaluate the performance of its hospitals in terms of how many labor hours are used relative to how many labor hours are needed. The variables assigned for this analysis are: y = monthly labor hours required x1
1. The owner of Maumee Motors wants to study the relationship between the age of a car ad its selling price. Listed below is a random sample of 12 used cars sold at Maumee Motors during the last year. Car Age (years) Selling Price ($000) Car Age (years) Selling Price ($000) 1 9 8.1 7 8 7.6 2 7 6.0 8 11 8.0 3 11 3.6
The linear trend forecasting equation for an annual time series containing 40 observations (from 1963 to 2002) on real net sales (in billions of constant 1995 dollars) is Y = 1.2 + 0.5X What is the fitted trend value for this time series on real net sales for the tenth year?
Now that warm weather is finally upon us (or at least in some parts of the country), is there a possible relationship between crime rates and ice cream sales? In the world of regression analysis, this is called an indirect relationship. As there is no direct correlation between the 2 variables. However, what if you identifi
I. Convert the Summer Historical Inventory Data into an index II. Use the time series data from the converted index to forecast the inventory data for the next year III. Graph of choice Time Series. A Time series is a sequence of measurements, typically taken at successive points in time. Time series analysis includes
See attachment for problems 1. (a) How does correlation analysis differ from regression analysis? (b) What does a correlation coefficient reveal? (c) State the quick rule for a significant correlation and explain its limitations. (d) What sums are needed to calculate a correlation coefficient?
Month Sales 1 6 2 13 3 24 4 36 Use linear regression to forecast sales for month 5. Prob 1b Use quadratic (y=ax2 + bx + c) to forecast sales for month 5.