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
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
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
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
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
David Gallano, a wine merchant, has collected opinions on grape wine quality from a sample of his customers.
1. David Gallano, a wine merchant, has collected opinions on grape wine quality from a sample of his customers. These customers tasted wine made from grapes grown in three regions of the country. They rated the wine quality on a scale of 1 (best) to 4 (worst). The following is the data obtained for customer quality ratin
In a multiple regression equation two independent variables are considered, and the sample size is 25.
In a multiple regression equation two independent variables are considered, and the sample size is 25. The regression coefficients and the standard errors are as follows. b1= 2.677 sb1= 0.56 b2= -0.880 sb2= 0.71 Conduct a test of hypothesis to determine whether either independent variable has a coeffic
Many regions along the coast in North and South Carolina and Georgia have experienced rapid population growth over the last 10 years.
Many regions along the coast in North and South Carolina and Georgia have experienced rapid population growth over the last 10 years. It is expected that the growth will continue over the next 10 years. This has resulted in many of the large grocery store chains building new stores in the region. The Kelley's Super Grocery Store
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. 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 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
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
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
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
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
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
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: