A consumer organization wants to develop a regression model to predict gasoline mileage (MPG) based on the horsepower of the car's engine and the weight of the car (in pounds). A sample of 50 recent car models was selected, with the results shown at left. Q-12a: Write the multiple regression equation. (Use four decimals of p
See attached file. Please show all working in same excel file. A real estate company in downtown Miami would like to be able to predict the monthly rental cost for apartments, based on the size of the apartment, as defined by square footage. A sample of 25 apartments in a particular residential neighborhood was chosen.
Please refer to the attachment for details.
Consider the airline ticket data in the file P13_01.xlsx. a. Create a time series chart of the data. Based on what you see, which of the exponential smoothing models do you think should be used for forecasting? Why? b. Use simple exponential smoothing to forecast these data, using no holdout period and requesting 12 months
See attached file for datasets on low birth weight and related risk factors. * Must do a complete data analysis and report. * Can use any statistical software, but R software is preferred. If software other than R is used, then detailed descriptions of techniques used are to be provided. * Details of the requirements are i
See attached file. The file housing.xls contains sample data on the assessed price of a house (in $1,000s) and the house's floor space (in square feet). Pls Do with Excel, except where stated, and explain your results. a. Determine the proper dependent variable and then plot a scatter diagram with the dependent variable on
For Each Equation I need (F) written out.... There are two 12.48 In the following regression, X = weekly pay, Y = income tax withheld, and n = 35 McDonald's employees. (a) Write the fitted regression equation. W Y = 0.0343X + 30.7963 (b) State the degrees of freedom for a two tailed test for zero slope, and use Appe
See attached files. 9 questions: Chi-Square Tests and Nonparametric Tests/Simple Linear Regression 1. A sample of 500 shoppers was selected in a large metropolitan area to determine various information concerning consumer behavior. The results are summarized in the following contingency table: Enjoy Shopping for clothin
8. The regional transit authority for a major metropolitan area wants to determine whether there is any relationship between the age of a bus and the annual maintenance cost. A sample of 10 buses resulted in the following data. (Use of TI - 83 plus calculator permited given that steps are provided). Age of the Bus (yrs.)
Ask a sample of people if they take vitamins/supplements daily and how many (see data attached). Conduct a regression analysis to determine if age (independent variable) has any effect on the number of vitamins/supplements people take. Use the "Correlation and Regression" spreadsheet. Again, enter data in yellow and read output in blue. Explain your answer.
Ask a sample of people if they take vitamins/supplements daily and how many (see data attached). Conduct a regression analysis to determine if age (independent variable) has any effect on the number of vitamins/supplements people take. Use the "Correlation and Regression" spreadsheet. Again, enter data in yellow and read outp
[See attached files.] This assignment introduces you to applications of simple and multiple regression. You will apply these models for predicting and forecasting and, determining the strength of the relationship between a variable y and a number of variables X1, ..., Xp. Skill- Building Exercises: ? 1. For the Home M
[See attached file.] The ThermoStar Case ThermoStar has been producing residential thermostats for over 50 years. Looking over the past 20 quarters (5 years) of the different product lines, the general manager has been trying to get a handle on sales, costs, and production, and has asked for your help. Your response t
See attached file for clarity. Data Item Quantity (# of Books Produced) Total Cost of Production 1 2 $30 2 5 $40 3 8 $73 4 10 $100 5 11 $130 6 12 $90 7 14 $150 8 15 $160 9 16 $160 10 17 $180 11 18 $240 12 19 $280 13 20 $180 14 21 $181 15 22 $185 16 23 $190 17 24 $200 18 25 $200 19 26 $275 20 28 $215 21 30
In Bazemore v. Friday, 478 U.S. 385 (1986), a case involving pay discrimination in the North Carolina Extension Service, the plaintiff, a group of black agents, submitted a multiple regression model showing that, on average, the black agents' salary was lower than that of their white counterparts. When the case reached the court
See attached file. (15.23) For the National Football League, ratings for the alltime leading passers were as shown below. Also shown for each quarterback is the percentage of passes that were interceptions, along with the percentage of passes that were touchdowns. Player Rating TD% Int
See attached file for tables. Set of problems. Show all essential work. Problem 1 Consider the following prices and accuracy ratings for 27 stereo speakers. (a) Make a scatter plot of accuracy rating as a function of price. (b) Calculate the correlation coefficient. At ? = .05, does the correlation differ from zero?
See attached files. The excel document is the data needed for the question and the other 3 uploads are the references to the question in the problem: Hourly Earnings and Unemployment Rate Complete Problem 5.29 of Chapter 5. 5.29. Refer to Example 5.6 in the chapter. It was shown that the percentage change in the ind
See the attached file forthe formula. Econometrics 2.12 Table 2-9 gives data on the Consumer Price Index (CPI) for all items (1982-1984=100) and the Standard & Poor's (S&P) index of 500 common stock prices (base of index: 1941-1943=10). Complete letters a through e in the questions that follow the table. Table 2-9
Identify the types of processes and analyses used in HR that use data analysis and evaluation. Discuss generally how statistics can be used in hiring, turnover, performance management, training, culture assessments, and other dashboard indicators of overall health and performance of the employee group. Consider how
Ch. 13, 14, & 16 of Operations Management for Competitive Advantage. Chapter 13: a. From the choice of simple moving average, weighted moving average, exponential smoothing, and linear regression analysis, which forecasting technique would you consider the most accurate? Why? b. Complete Problem 17 - be sure to sho
12.33 Use Excel's Add Trend-line feature to fit a linear regression to the scatter plot. Is a linear model credible? 12.35 Use Megastat to fit the regression model, including residuals and standardized residuals. 12.37 ( a) based on the R2 and ANOVA table for your model, how would you assess the fit? (b) Interpret the p-v
See attached file for clarity. Study Discussion Questions for final Problem Set 2: Chapter 16 and 17 Chapter 16 2. What information is provided by the numerical value of the Pearson correlation? The numerical value of the Pearson correlation indicates how well the data points fit a straight line. And the value of 1.0
See attached data file. Using the salary.sav data file found in SPSS/PASW, predict the natural log of beginning salary from gender, education level, work experience, and minority status (variables sex, ed level, work, and minority). Save the leverages, Studentized residuals, standardized changes in the regression coefficient
31.) A multiple regression analysis between yearly income (Y in $1,000s), college grade point average (X1), age of the individuals (X2), and the gender of the individual (X3; zero representing female and one representing male) was performed on a sample of 10 people, and the following results were obtained. Coefficients
You are a manager with Appetizer. The company owns a chain of restaurants in the United States. Appetizer is looking for an opportunity to expand. As part of a market analysis, you have to send a handout in a Word document to the COO of the company, exploring the relationship between the expenditure by people on purchasing food
A statistics instructor, wishes to study the relationship between the number of absences students have and their final course grades. The data obtained for o randomly selected statistics students is given below:... (Please see attached files) (a) Find the equation of the linear regression line. (b) What is the predicted final
1. Routine physical examinations are conducted annually as part of a health service program for the employees. It was discovered that 8% of the employees needed corrective shoes, 15% needed major dental work and 3% needed both corrective shoes and major dental work. What is the probability that an employee selected at random wil
1. An obstetrician wants to learn whether the amount of prenatal care and the wantedness of the pregnancy are assoicated. He randomly selects 939 women who had recently given birth and asks them to disclose whether their pregnancy was intended, unintended, or mistimed. In addition, they were to disclose when they started recei
Please help with the following sales and advertising question. 1. Regression analysis was applied between sales in ($1000) and advertising(in $100), and the following regression function was obtained: Y = 61 +4.1X Based on this regression line, if advertising is $10,000, the point estimate for sales (in dollars) is what?
5. The city council of Pine Bluffs is considering increasing the number of police in an effort to reduce crime. Before making a final decision, the council asks the chief of police to survey other cities of similar size to determine the relationship between the number of police and the number of crimes reported. The chief gather