The scatter plot using excel has been completed as well as the least squares regression model. The part where assistance is needed is in parts b and c of question 2 and question 4. The Rio-River Railroad, headquartered in Santa Fe, New Mexico, is trying to devise a method for allocating fuel costs to individual railroad cars
In a concept formation study, 12 subjects were randomly assigned to three different experimental conditions and then given four trials in the solution of a problem. For each trial, the number of minutes taken to solve the problem was recorded. The results were as follows: (See the attached file for data table) a) State a
Subject: Multivariate model Details: I need to know how to report the findings from this type of model
Making sense of the data in Excel, in order to predict the two most influential , and the two least influential parameters. The enclosed table shows details from a sample of students. All students had to jump as high as possible, the results were measured in CMs. Out of all the personal details, Genda, Height, weight, B
Cost estimation and using multiple regression: University Hospital has prepared a schedule of estimated overhead costs for its blood test unit for the coming year on the assumption that production will be 80,000 tests for the year. Costs have been classified as fixed or variable, according to the controller's judgment. See a
In my paper, I look at the effect of immigration on marital status among different ethnic groups. I would like to get a clear interpretation of my binary logistic regression findings. Although I am including the full SPSS output (in an excel format), I am particularly interested in the meaning of all exp(b) and Nagelkerke R Squa
See the attachments. A used-car dealer randomly selects 100 three-year old Holden Barinas that were sold at auction during the past month. Each car was in top condition and was equipped with automatic transmission, AM/FM cassette tape player, and air conditioning. The dealer recorded the price and the number of km on the odomet
The following is a list of grade levels and ages for 15 students: Age Grade 16 10 15 9 15 10 14 8 12 6 11 5 11 6 10 4 9
Lenny's, a national restaurant chain, conducted a study of the factors affecting demand (sales). The following variables were defined and measured for a random sample of 30 of its restaurants. Y = Annual restaurant sales ($000) X1 = Disposable personal income per capita of residents within 5 miles radius X2 = License to se
An analyst would like to predict water consumption in a city based on daily temperature. She has gathered the following data for a random sample of n= 7 days. Temperature ( C) 40 5 25 15 10 30 35 Water Consumption(million gallons) 225 25 150 100 75 125 175 Using the following sums and sums of squares and cross-products
I need to do the following: Summarize my finding, ensure that all graphs are plotted (please let me know what other graphs need to be included. I need to forecast using two methods. I need to know what columss I should forecast? Are they the original columns given (year, population, dollar, rate)?
Question: Find the forecast of the quaterly earnings per share for Price Club for each quarter by using the naà ¯ve approach. See above mentioned forecast values. SECOND PART OF THE QUESTION: The forecast for first-quarter 1994 is the value for fourth quarter 1993,.57. HOW DO I FIND THE ACTUAL FORECAST? I can use cumu
1. If the expected value of Y for the ith observation in a regression model is 35, how could it be that the observed value is 33? 2. In a study of the determination of prices of final output at factor cost in the United Kingdom, the following results were obtained on the basis of annual data for the period 1951-1969: PFt
Home-Schooled Pupils are Making Colleges Sit Up and Take Notice The Wall Street Journal, February 11, 2000. Education in the home rather than in public schools is becoming more popular in this country. More children are withdrawing from public schools in favor of learning their lessons at home. One of the possible reasons fo
Mr. James McWhinney, president of Daniel-James Financial Services, believes there is a relationship between the number of client contacts and the dollar amount of sales. To document this assertion, Mr. McWhinney gathered the following sample information. The X column indicates the number of client contacts last month, and the Y
What forecasting methods are used at your organization? Who does the forecasting? What is forecasted? What should be forecasted?
One of the editors of a major automobile publication has collected data on 30 of the best-selling cars in the United States. The data are in a file called Automobiles( attached). suppose the magazine editor wishes to examine the relationship between price of the vehicle and the horsepower of the engine. a) Toyota considered
One of the editors of a major automobile publication has collected data on 30 of the best-selling cars in the United States. The data are in a file called Automobiles( attached). The editor just purchased a Cadillac Sedan DeVille which weighs 4,012 pounds. His previous car was a Toyota Camry which weighs 3,241 pounds.. a) The
A 1998 article in Fortune magazine entitled " The 100 Best Companies to Work for in America" (January 12, 1998) contained data on the 100 companies. These data are included in the data file called Best-Companies ( attached). Two variables of interest are the revenues of the company and the number of hours of training per year pe
One of the editors of a major automobile publication has collected data on 30 of the best-selling cars in the United States. The data are in a file called Automobiles( attached). The editor is particularly interested in the relationship between highway mileage and curb weight of the vehicles. a) Develop a linear regression mo
The following data have been collected by an accountant who is performing an audit of account balances for a major retail company. The population from which the data were collected represented those accounts for which the customer had indicated the balance was incorrect. The dependent variable, y, is the actual account balance a
The State Department of Transportation has conducted a study of 100 randomly selected vehicles in which the speed of the vehicle and age of the driver were measured. The Data were collected from a stretch of highway that produces an unusually high accident rate. A regression model was developed, with vehicle speed being predicte
You are given the following results from computations pertaining to a simple linear regression application. Y=5,723.0+145x n= 25 Sb1=10.80 a) based on the statistics supplied, can you conclude that there is a significant linear relationship between x and y? test at a significant level of 0.05 b) interpret the slope coef
A publishing company in New York is attempting to develop a model that can use to help predict sales for textbooks it is considering for future publication. The marketing department has collected data on several variables from a random sample of 15 books. These data are given in the attached excel file. Answer these questions
Interpreting Summary Output for Simple Linear Regression (Round all calculations to 4 places.) Using the second attached BALDOR data and Excel output, complete the following: 1. What is the value of the correlation coefficient? 2. What is the value of the coefficient of determination? 3. What is
Using the Excel SUMMARY OUTPUT below, complete the following: All calculations accurate to four decimal places 1.) What is the value of the correlation coefficient? 2.) What is the value of the coefficient of determination? 3.) What is the value of the y-intercept of the least squ
Question #1: The following data have been collected by an accountant who is performing an audit of paper products at a larger office supply company. The dependent variable, y, is the time taken (in minutes) by the accountant to count the units. The independent variable, x, is the number of units on the computer inventory record.
In this problem, a multiple linear regression analysis is done with the software Minitab and the results of the analysis are interpreted. Using the Minitab output, the following questions are answered. a) Report the estimated regression equation and the value of R-square. b) Construct a 95% confidence interval for the slope
Multiple choice/ short answer See attached revisedq1.doc Word document for the multiple choice questions. Appears part of the information needed to answer was missing from the original posting. The information is now included in the revised document.
In this problem, the computer output from a logistic regression analysis is provided. We are asked to provide the following: a) Test the model significance at the .05 level. b) State the null and alternative hypothesis, the p-value and the decision from the hypothesis test. c) State the estimated regression