1. Consider the data shown in this table measured in a sample of n=25 undergraduates in an on-campus survey of health behaviors. Enter the data into an excel worksheet for analysis. 2. Estimate the multiple linear regression equation relating number of cups of coffee per week, female gender, and number of hours of exercise pe
The data table below tabulates a Pizza Parlor's advertising expenditures and sales for 8 consecutive quarters. The marketing manager wants to know how much of an impact current advertising will have on sales two quarters from now. When running a regression with the dependent variable "Sales" and the independent variable "A
I have also attached a sample xls file that contains the 5 steps referred to in the word doc. The data is located in the movie.xls file. Develop a regression model for movie demand. Follow the five steps outlined in the sample XLS file. ? Accomplish a correlation table and scatter plots with trend lines of all of the varia
37. A regional commuter airline selected a random sample of 25 flights and found that the correlation between the number of passengers and the total weight, in pounds, of luggage stored in the luggage compartment is 0.94. Using the .05 significance level, can we conclude that there is a positive association between the two variables? 40. 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 revenue per day in the restaurant. Below is a sample of 25 days (Monday through Thursday) from last year showing the restaurant income and number of rooms occupied. Use a statistical software package to answer the following questions.
37. A regional commuter airline selected a random sample of 25 flights and found that the correlation between the number of passengers and the total weight, in pounds, of luggage stored in the luggage compartment is 0.94. Using the .05 significance level, can we conclude that there is a positive association between the two va
Q17.26 (pp661). The dean of a law school has developed a regression equation for estimating the starting salary (thousands of dollars) of a new graduate on the basis of two independent variables: x1 = the score on the Law School Admission Test (LSAT) at the time of the application, and x2
Problem 15 in Chapter 16 described a study examining the effectiveness of a 7-Minute Screen test for Alzheimer's disease. The study evaluated the relationship between scores from the 7-Minute Screen and scores for the same patients form a set of cognitive exams that are typically used to test for Alzheimer's disease. For a sampl
In preparation for my final in two weeks, I have this set of study problems. In order to ensure I am working these correctly, I have created problems based of study problems and wish to compare work. Please complete the problems, show solutions in excel if applicable and explain. I really need to understand the concept as the
Confidence Interval of Pearson Product-Moment Correlation Coefficient and Correlation Hypothesis Test
A woman was interested in the relationship between the pollen count and the severity of her allergy symptoms. She developed a questionnaire that measured the severity of her symptoms with higher scores indicating worse allergy symptoms. She filled out and scored the questionnaire on 14 randomly selected days. She also had a f
This part of the quote, "The formulation of a problem is far more often essential than its solution, which may be merely a matter of mathematical or experimental skill" illustrates the following which I want you to expand on: 1) Planning and Designing is often the most important step of s research process. The way you design and collect your data is more important than the analysis of the data and subsequent interpretation of the result of the analyses.
This part of the quote, "The formulation of a problem is far more often essential than its solution, which may be merely a matter of mathematical or experimental skill" illustrates the following which I want you to expand on: 1) Planning and Designing is often the most important step of s research process. The way you design
Regression analysis is often mentioned as least-squares regression. Why?
Define autocorrelation in the following terms: a. In which type of regression is it likely to occur? b. What is the negative impact of autocorrelation in a regression? c. Which method is used to determine if it exists? d. If found in a regression, how is autocorrelation eliminated? Define multicollinearity in the followin
Please show all work. 5. The chairperson of the department of management at State University wants to forecast the number of students who will enroll in production and operations management (POM) next semester, in order to determine how many sections to schedule. The chair has accumulated the following enrollment data for th
Moving Average Forecast, Exponential Smoothing Forecast, Adjusted Exponential Smoothing Forecast, MAD, MAPD, Cumulative Error, Comparison among different Forecast Techniques and Regression Analysis
1. The saki motorcycle dealer in Minneapolis wants to make an accurate forecast of demand for the Saki Super TXII motorcycle during the next month. Because the manufacturer is in Japan, it is difficult to send motorycles back or reorder if the proper number is not ordered a month ahead. From sales records, the d
Construct a 95 per cent confident interval given the information below: A certain brand of fluorescent light tube was advertised as having an average illumination life-span of... Given the following data from two independent samples from which the population standard deviation is known, conduct a two-tailed hypothesis test to d
See attached data file. Prepare a report using Excel as your processing tool to process three simple regression analyses. 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 d
A study is conducted in patients with HIV. The primary outcome is CD4 cell count, which is a measure of the stage of the disease. Lower CD4 counts are associated with more advanced disease. The investigators are interested in the assocition between vitamin and mineral suppliments and CD4 count. A multiple regression analysis is
We are given a multiple regression model : InQt=1.2789-0.1647 In Pt+ 0.5115 In It + 0.1483 In P't - 0.0089T - 0.961D1t - 0.1570D2t-0.0097D3t Its purpose is to describe the relationship between the terms on the right (the independent variable) to Qt (the dependent variable. We find values of each variable be taking a random
See attached data file to complete this task. Prepare a report using Excel as your processing tool to process 3 simple regression analyses. Create a graph with the trend line displayed for each of the 3 different regressions. First run a regression analysis using the BENEFITS column of all data points in the AIU data set
See the attached file. PG 2 -6 The US Navy selected 16 hospitals that were believed to be efficiently run. They conducted a regression analysis to evaluate the performance of the hospitals in terms of how many labor hours used relative to how many labor hours needed. Y= monthly labor hours required X1= monthly X-ray e
See attached file. Accu-copiers Inc sells Accu 500 copy machines. As part of standard contract, they perform routine servicing of the copier. To obtain the time it takes to perform the routine service they collected 11 service calls. The service call information revealed the the following. Refer to Table 10C attached.
Short Answer - One paragraph per response; your own words! Reference links may be included. Question 1: The F test is used in Analysis of Variance (ANOVA). When would a researcher use an ANOVA? Explain. Questions 2: A research assistant is contemplating whether to use a One Way ANOVA or a Two Way ANOVA. The research as
You are a realtor with a small business. You use a simple 2 variable linear regression analysis for quick first glance house price estimates using square footage of the house. You are asked by a customer what the price for his house would be given that his house has 1,500 square feet. The number you are trying to explain is the
Test the Hypothesis that homes located closer to the centre of the city, are higher in price than those homes located further away from the centre of the city. -Perform a regression hypothesis test on the data -Include a graph showing the results -Include the results of your computations, using graphical and/or tabular met
A 10 year study by the American Heart Association provided data on how age, blood pressure and smoking relate to the risk of strokes. Data from a portion of this study are shown below. Risk is interpreted as the probability (times 100) that a person will have a stroke over the next 10 year period. For the smoker variable, 1 indi
5 Answer questions 5-8 using the following information: Test the hypothesis that the treatment means for samples given below are equal. Use the .01 significance level. Treatment 1 Treatment 2 Treatment 3 22 34 13 20 31 10 21 25 14 18 25 11 19 32 30 The decision rule is: Choose one answer. a. Reject the nul
We want to determine the primary factors that affect Motor Vehicle Theft crime rates in the United States. The statistical analysis of the data involves multiple-regression analysis. This problem is for Graduate/Masters level 1.What are the primary determinants of Motor Vehicle Theft crimes in the United States? 2. What
Artsy Case The Artsy Corporation has been sued in the United States Federal Court on charges of employment discrimination under Title VII of the Civil Rights Act of 1964. (Artsy is an actual corporation and the data given in the case is real, but the name has been changed to protect the firm's true identity.) The litigation at
A Survey of 50 Companies In January '08, fifty customers of a lumber manufacturer were surveyed regarding their satisfaction with products and service. These customers buy from the supplier and sell to retail chains like Home Depot and Lowes. Shortly after, the manufacturing company was sold. In June '08, the customers were
Explain why most researcher use the default(Enter) method for model building.
This solution describes how to do multiple regression using Excel and the Megastat plugin. Students are given step-by-step instructions on how to use the MegaStat plugin for Excel and told why Excel's Data Analysis Toolpak isn't reliable for rigorous statistical analysis. Attachments include example spreadsheets, a video tutoria