Explore BrainMass

Regression Analysis

Regression Analysis for he Fresh Detergent Case in Megastat

Hello, I have been asked to do this question in MEGASTAT, which is an add-on to Excel. The problem here is I don't know how to use MEGASTAT that well. I am hoping someone could complete this textbook question using Megastat, and show how they got the answer and graphs. Thank you. The Fresh Detergent Case The follo

Paper on Regression Analysis

Project Paper Business Statistics Bryant/Smith manual Case 28: We want to find an equation that gives the selling price of a house. Things you'll want to do are: 1. Use regression analysis to derive a model of selling prices of houses in Eastville. Interpret your final model and its coefficients within the context of t

Regression analysis

Need full explanation - Please see attachment. Information is on Tab 1 and data on Tab 2. Please use SPSS. You are a statistical analyst for a computer manufacturing company CompXXX. The COO of CompXXX has requested that you review production and delivery data for two popular CompXXX computer models, UltraModel and Mobil

Regression Analysis of Test Scores and Stress

See attached. 7. It is recommended that you use the computer EXCEL sheet attached to help you answer the following questions: Write the answers in the provided space. An answer saying "see attached page" is not an option. There are almost no calculations. Most of the answers are on the EXCEL spreadsheet. X Y Stress Te

Regression Equation, Standard of Error Estimate, and a Typical Seasonal Index

14. 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

Mr. William Profit is studying companies going public for the first time

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

Regression of Gross Income

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

Regression, Least squares and Correlation Coefficients

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

R&D is considered one of the vital components of IT company performance.

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

Multiple Regression & Correlation Analysis

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

Regression, Forecasting, Minimization

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.

Regression Line, RMSE and Interpretation of Slope

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

Forecasting, Time Series

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.

Examining Regression Analysis

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: a. Determine the correlatio

Linear Regression and Correlation

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

Regression - College Graduation Rates

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

Business Statistics : Hypothesis Testing, Regression and Data Analysis

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

Correlation Coefficient

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

The declaration of sleep is X and TV viewing is Y

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

Graphing JTI's costs

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

Linear Regression Analysis

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: