A candy bar manufacturer is interested in trying to estimate how sales are influenced by the price of their product. To do this the company randomly chooses 6 small cities and offers the candy bar at different prices. Using candy bar sales as the dependent variable, the company will conduct a simple linear regression on the data
Question: A candy bar manufacturer is interested in trying to estimate how sales are influenced by the price of their product. To do this the company randomly chooses 6 small cities and offers the candy bar at different prices. Using candy bar sales as the dependent variable, the company will conduct a simple linear regression o
A candy bar manufacturer is interested in trying to estimate how sales are influenced by the price of their product. To do this the company randomly chooses 6 small cities and offers the candy bar at different prices. Using candy bar sales as the dependent variable, the company will conduct a simple linear regression on the data
................................................................................................... Business / Managerial Accounting - Please select ONLY: a,b,c, or d. ................................................................................................... * What is the purpose of regression analysis? a. To
Given the following data: Tax collections New Car Registrations 1 10 1.4 12 1.9 15 2 16 1.8 14 2.1 17 2.3 20 Determine the following: a) The least squa
Attached Data Files: FUNDS - This file contains 185 rows of data points 1st Column : Fund Name 2nd Column : Fund Type (Balanced = 1, Equity-Income = 2, Growth and Income = 3, Growth = 4, Aggressive-Growth = 5, Small-Company = 6, International and Global =7) 3rd Column : Five Year investment performance 4th Column : 1992 Retu
See attached file for full problem description. A. What is the sample size? B. Compute the value of R2. C. Compute the multiple standard error of estimate. D. Conduct a global test of hypothesis to determine whether any of the regression coefficients are significant. Use the .05 significance level. E. Test the regressio
Given the following ANOVA table: SOURCE DF SS MS F Regression 1 1000.0 1000.00 26.00 Error 13 500.0 38.46 Total 14 1500.0 A. Determine the coefficient of determination. B. Assuming a direct relationship between the variables, what is the
I need help in producing SPSS output for a hotel survey exercise. SPSS data file provided. I will need a Descriptive Analysis done in SPSS with graphs and output file. Also, solutions with calculations to questions in the attached MS Word file.
2a. Perform a simple regression analysis to forecast the number of apartment units leased, based only on average lease price. What is your forecast if the lease price is to be $455? Semester Average lease price x Number of Units leased y X^2 xy Y^2 1 450 291 202500 130950 84681 2 460 228 211600 104880 51984 3 450 252 20
16. Does a heavier bowler knock down more pins? Jim Samuels, manager of Maple Lanes, asked 15 men's league players to report their body weight (lb.) and their league average, rounded to the nearest pin. Results are shown in the table attached. Make sure you include your chart and calculations from excel as a part of your a
(See attached file for full problem description)
A recent article in Business Week listed the "Best Small Companies." We are interested in the current results of the companies' sales and earnings. A random sample of 12 companies was selected and the sales and earnings, in millions of dollars, are reported below. (see data in attached file) Let sales be the independent va
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
4. Generations of athletes have been cautioned that cigarette smoking retards performance. One measure of the truth of that warning is the effect of smoking on heart rate. To examine this impact, six of each of non-smokers, light smokers, moderate smokers, and heavy smokers undertook sustained physical exercise. Their heart
Forecasting Exercise Year Demand ( in 1000's ) 1 13 2 17 3 18 4 21 5
Laura wanted to build a multiple regression model based on advertising expenditures and Coffee Time's price index. Based on the selection of all normal values, she obtained the following: Multiple R = 0.738 R-Square = 0.546 By using lagged values, she came up with the following: Multiple R = 0.755 R-Square = 0.570
A mortgage department of a large bank is studying its recent loans. Of particular interest is how such factors as the value of the home (in thousands of dollars), education level of the head of the household, age of the head of the household, current monthly mortgage payment (in dollars), and gender of the head of the household
Super Markets, Inc. is considering expanding into the Scottsdale, Arizona, area. Ms. Luann Miller, Director of Planning, must present an analysis of the proposed expansion to the operating committee of the board of directors. As a part of her proposal, she needs to include information on the amount people in the region spend per
Fran's Convenience Marts are located throughout metropolitan Erie, Pennsylvania. Fran, the owner, would like to expand into other communities in northwestern Pennsylvania and southwestern New York, such as Jamestown, Corry, Meadville, and Warren. As part of her presentation to the local bank, she would like to better understand
(See attached file for full problem description) 14.16 Mike Wilde is president of the teachers' union for Otsego School District. In preparing for upcoming negotiations, he would like to investigate the salary structure of classroom teachers in the district. He believes there are three factors that affect a teacher's salary:
I need to use this information to create numbers (imaginary numbers) and perform regression testing. Surveys carried out by a manager for assessing overall ratings of employees, in the form of marks out of 100 for each attribute. Attributes (the variables) might include handling of employee complaints assessing employee pay r
To estimate crimes in a City with 20 police by determining the line of regression. See attached file for full problem description. Use the "Correlation" tool in the DataAnalysis ToolPak for parts "c" and "d". Use the Chart Wizard in the Insert, Chart menu options for part b. X Y Oxford Starksdal
A regression equation regarding repair cost of car. The repair cost is the dependent variable and the age of the car is the independent variable. The situation is that as the age of the car increases, the repair cost increases also. The regression equation is Y'= $80 + 20X 1. What is "20" means in the equation? 2. What
Mr. William Profit is studying companies going public for the first time. He is particularly interested in the relationship between the size of the offering and the price per share. A sample of 15 companies that recently went public revealed the following information. Company Size ($ millions), X Price per Share, Y Company Si
Sales Number of Units Chain ($billions) (1,000) ------------------------------------------------- McD's 17.1 12.4 Burger King 7.9 7.5 Taco Bell 4.8 6.8 Pizza Hut 4.7 8.7 Wendy's
To estimate sales for 40 contact by finding the line of regression. See attached file for full problem description.
Can you please walk me throught this problem? I am stuck and excel is not cooperating. Listed below are the net sales for Schering-Plough Corporation (a pharmaceutical company) and its subsidiaries for the six years from 1997 to 2002. The net sales are in millions of dollars. Year Net Sales 1997 $ 6,714 19
The following sample observations were randomly selected: X: 5 3 6 3 4 4 6 8 Y: 13 15 7 12 13 11 9 5 a. Determine the regression equation. b. Determine the value of Y when X is 7.
What strategy would you recommend to solve the challenge of demand forecasting?