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
To answer the following question, please use statistical software like SPSS. Data can be found in the attached excel sheet. 4. 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 h
To answer the following question, please use statistical software like SPSS. Data can be found in the attached excel sheet. 3. 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 distr
To answer the following questions, please use statistical software like SPSS. Data can be found in attached excel sheet. 2. Super Markets, Inc. is considering expanding into the Scottsdale, Arizona area. You, as director of planning, must present an analysis of the proposed expansion to the operating committee of the board
To answer the following question, please use statistical software like SPSS. Data can be found in the excel sheet attached. 1. 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 reven
Refer to the Real Estate data, which reports information on homes sold in Denver, Colorado, last year. a. Let selling price be the dependent variable and size of the home the independent variable. Determine the regression equation. Estimate the selling price for a home with an area of 2,200 square feet. b. L
The following table shows the number of workdays absent based on the length of employment in years. Number of workdays absent 2 3 3 5 7 7 8 Length of employment (years) 5 6 9 4 2 2 0 a. What is the independent variable? What is the dependent variable? b. Using Megastat or Excel
5. A sample survey of boat owners in southeast Florida has yielded the following data on boat costs and buyer income. (See Excel attachment for data and solution) a. Compute with statistical software a linear regression of Y on X. How do you interpret the results? b. Interpret the coefficient of correlation squared.
Please see attached file for full problem description. R&D is considered one of the vital components of IT company performance. It is common believe that IT R&D spend will directly impact the company revenues. The following data shows the annual IT spending of a company A and annual Revenue (data with one year lag) over the
Problem: A sales manager for an advertising agency believes there is a relationship between the number of contacts and the amount of sales. To verify this belief, the following data were collected: (SEE ATTACHED DATA FOR THIS PROBLEM-thanks) (a) Create a scatter diagram. Put the independent variable on the X (
Question (Lind: Chapter 19, exercise 28) Sales of roof material, by quarter, since 1997 for Carolina Home Construction, Inc. are shown below (in $000). Quarter Year I II III IV
NB: PLEASE DO EVERYTHING IN EXCEL: Refer to the Real Estate data, at: http://highered.mcgraw-hill.com/sites/0073030228/student_view0/index.html which reports information on homes sold in the Denver, Colorado, area during the last year. Use the selling price of the home as the dependent variable and determine the
Please see attached file for full problem description. Ques. 1: Suppose that the sales manager of a large automotive parts distributor wants to estimate as early as April, the total annual sales of a region. Based on regional sales, the total sales for the company can also be estimated. If, based on past experience, it is fou
"What are some examples of practical applications for correlation and regression analysis that might be of use to us?" The goal is to get people thinking about how they can actually use correlation and regression in their real life, and where and how can they can really benefit from these techniques? Please provide ex
Please see attached file. 1. Four alternative manufacturing processes are being considered for our company. The below information on the profitability of the four processes in three different demand levels is provided for your information in order to answer upper management's below listed questions.
A regression (trend) line model is fit to examine the relationship between daily high temperatures (T), measured in degrees, and power consumption (P), and measured in thousands of kilowatt hours in a small Kansas town. The data are collected in the months of July and August. A straight line is found to fit the data relativel
The following data show the time series of the most recent quarterly capital expenditures (in billions of dollars) for the 1000 largest manufacturing firms: 24, 25, 23, 24, 22, 26, 28, 31, 29, 32, 37, and 42. a. Develop a linear trend equation for the time series. b. Graph the time series and the linear trend equation.
I need to identify a business research issue, problem, or opportunity that can be examined using regression analysis. 1- Prepare a paper examining a regression analysis on your collected data. Begin by describing the research issue, problem, or opportunity and the accompanying data. Then, perform a regression analysis on your
Question 1. Refer to the Wage Data which reports information on annual wages for a sample of 100 workers. Also included are variables relating to the industry, years of education, and gender for each worker. Wage Data is at: http://highered.mcgraw-hill.com/sites/0073030228/student_view0/index.html a. Determine the correlatio
LINEAR REGRESSION AND CORRELATION Please note ALL answers and explanation is to be done in EXCEL -no word documents. Question 1: The Bardi Trucking Co. located in Cleveland Ohio, makes deliveries in the great Laes region, the southeast and the Northeast. Jim Bardi, the president, is studying the relations
"The linear regression line is sometimes called the least squares line. Why?" What is the idea of "least squares"? What is the connection between "least squares" and linear regression? Could "least squares" and regression be generalized to more complicated cases than lines?
Regression problem must be neatly prepared and typed (double spaced) with all relevant printouts from SPSS included. You MUST refer to your SPSS printout in each section, clearly explaining what you did and what were the results. consider a simple regression model (using only one independent variable) and will include 3 part
Please see attached file. 4. The variable plotted on the horizontal or X-axis in a scatter diagram is called the: a. scatter variable b. independent variable c. dependent variable d. correlation variable 5. Which of the following statements is not correct regarding the coefficient of correlation. a. It can range fr
1. Descriptive statistics 1.1 The variable "Stock" is the stock price of a company quoted on an international exchange. Give summary statistics for price and daily returns and comment your results. The information you produce should be contained in two pages maximum for tables and eventually graphs and one page for comments. 1
Four research participants take a test of manual dexterity (high scores mean better dexterity) and an anxiety test (high scores mean more anxiety). The scores are as follows. Person Dexterity Anxiety 1 1 10 2 1 8 3 2 4 4 4
Please perform the following statistical operations on the data provided in the attachment and compile your results in a Microsoft Word document: 1. Organize the data and create a scatter diagram 2. Calculate the correlation coefficient in terms of r 3. Determine the standardized regression coefficient 4. Predict fiv
Set up and solve a problem related to your workplace that is amenable to the use of regression analysis and solve it using regression analysis. Show all work.
See attachment for sample of graph and graph the month of April figures, please explain 1. why you use the method you choose 2. Are the cost more correlated with out units production or set up? Units Produced Cost Driver Month Units Produced Production Cost February 1950 $14900 March 2050 $14950 April* 8
Multiple problems - Super Markets, Inc. is considering expanding into the Scottsdale, Arizona, area.
Please see attached file for full problem description. --- 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 i
The Skelton Manufacturing company recently did a study of its customers. A random sample of 50 customer accounts was pulled from the computer records. Two variables were obser4ved: y = Total dollar volume of business this year x = Miles customer is from corporate headquaters The following statistics were computerd: