Given are five observations collected in a regretion study on two variables: x 2 6 9 13 20 y 7 18 9 26 23 a) what is the value of the standard error of the estimate? b) test for a significant relationship by using the t test Use a=.05
Using Excel as your processing tool, work through three simple regression analyzes. 1. First run a regression analysis using the BENEFITS column of all data points in the attached AIU data set as the independent variable and the INTRINSIC job satisfaction column of all data points in the attached AIU data set as the depend
EXCEL or manually calculated is acceptable. The Bradford Electric Illuminating Company is studying the relationship between kilowatt-hours (thousands) used and the number of rooms in a private single-family residence. A random sample of 10 homes yielded the following: NUMBER OF KILOWATT ROOMS HOURS
1. First run a regression analysis using the BENEFITS column of all data points in the AIU data set as the independent variable and the INTRINSIC job satisfaction column of all data points in the AIU data set as the dependent variable. Create a graph with the trendline displayed. What is the least squares regression line equatio
See the attached file. Molly Prickett has just purchased a relatively small manufacturing company. The Company employs approximately 125 hourly workers, all performing essentially the same assembly-line operation. These non-unionized workers are concerned because they believe their wages for the past 21 years did not keep up wi
I am having some trouble with a few problems. Any help is appreciated A grocery store owner is interested in determining if the average weight of a package of ground beef sold in the store weighs one pound. An appropriate null hypothesis for this study is a. H0: m = 1 lb b. H0: m ¹ 1 lb c. H0: m > 1 lb d. H0:
Discuss any limitations (inaccurate data; incomplete information; not enough samples for testing)can have an regression analysis. I need some pointers please.
Which of the following is not used to find a "best" model? a. adjusted r2 b. mallow's Cp c. Odds ratio d. all of the above
The Cp statistic is used a. to determine if there is a problem of collinearity b. if the variances of the error terms are all the same in a regression model c. to choose the best model d. to determine if there is an irregular component in a time series
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
(1) How is correlation analysis used in a business decision? (2) What is the standard error of estimate? Describe with an example. (3) What are the coefficients of the linear regression model and what do they mean? What are the various statistics reported in a regression output? (4) How do outlying observations affect reg
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
As the value of the correlation coefficient increases from 0 to 1, or decreases from 0 to -1, how do the points of the scatter plot fit the regression line?
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
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
A sociologist claims that the success of students in college (measured by their GPA) is related to their family's income. For a sample of 20 students, the coefficient of correlation is 0.40. Using the 0.01 significance level, can we conclude that there is a positive correlation between the variables?
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. 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. 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 (