Please see the attached Excel worksheet for my questions on correlation. I need to answer the following questions: A) Use the Excel Analysis ToolPak to find the linear correlation coefficient for the systolic and diastolic measurements. B) Use the Excel Analysis ToolPak to determine the linear regression equation that us
1, Explain the difference between the null and alternative hypothesis. Which one can be proven in a statistical sense? 2. What are the differences between one- and two- sample hypothesis tests? Describe the correct mathematical form for specifying the null and alternative hypotheses for both types of tests. 3. Explain Type I
For the 50 states, consider a multiple regression analysis to explain the number of new jobs created, using the number of new firms created and the percentage of fast-growth companies. The variables used are "new jobs" (in thousands), "new firms" (actual number of firms), and pct fast" (in percentage points, so that, for exampl
Find the equation of the regression line for the given data. Then construct a scatter plot of the data and draw the regression line. (The pair of variables have a significant correlation.) Then use the regression equation to predict the value of y for each of the given x-values, if meaningful. The table below shows the heigh
To get an even better model for predicting MBA performance, let's look at many variables. Create a multiple regression model predicting the MBA GPA using the BS GPA, the Hours studied per week, the Gender of the student, whether the student works full-time, and the student's age. Use a .05 significance level. After you create yo
12 Use technology to find the regression equation for the data shown in the table. Then answer the following. a) What is the standard error estimate? b) What is the coefficient of determination? What is the regression equation? Y = _______ + (_______)x₁ + (_______)x₂ (round three decimal places as needed) a) The s
A sample of 12 homes sold last week in St Paul, Minnesota, is selected. The results are shown below Home Size (1000 square feet) Home Price ($1000) 1.4 100 1.3 110 1.2 105 1.1 120 1.4 80 1 105 1.3 110 0.8 85 1.2 105 0.9 75 1.1 70 1.1 95 Create a scatterplot. Insert the trendline into the graph and show the reg
Can you help me create a scatterplot, with an inserted trend line, showing the regression equation using the data below? A sample of 12 homes sold last week in St Paul, Minnesota, is selected. The results are shown below. Home Size (1000s sq feet) Home Price ($1000) 1.4 100 1.3 110 1.2 105 1.1 120 1.4 80 1 105 1.3
1) Testing for a Linear Correlation Construct a scatter plot, find the value of the linear correlation coefficient r, and find the critical values of r from the table below using a=0.05. Determine whether the is sufficient evidence to support a claim of a linear correlation between the two variables. Airline Fares Listed be
I need help constructing a regression analysis. Using the attached spreadsheet and Word Doc help develop the following 3 regressions. Please show what is used as the Y and X ranges and explain the steps. A. Estimate a one factor, or CAPM, regression analysis of the following form: Ri - Rf = ?j + ?i(RM - Rf) B. Estimate
In a multiple regression model y' = -10 + 2x1 + 19x2 + 14x3 + 2x4, if the x1 value changes by 2, then the predicted value for y will change by (the 1,2,3,4 are all little numbers sit lower than then x-could not figure out how to type that correctly).
You are interested in finding out if a student's ACT score is a good predictor of their final college grade point average (GPA). You have obtained the following data and are going to conduct a regression analysis. ACT GPA 22.0 3.0 32.0 3.78 33.0 3.68 21.0 2.94 27.0 3.38 25.0 3.21 30.0 3.65 a) What is the R? What ty
Bill is doing a project for you in the marketing department. In conducting his analysis regarding consumer behavior and a new product that has come out, he tells you the correlation between these two variables is 1.09. What is your response to this analysis?
The gas tax and fuel use are shown. tax: 21.5, 23, 18, 24.5, 26.4, 19 Usage 1062, 631, 920, 686, 736, 684 How would I find y' when x = $0.25 "For this problem find the equation of the regression line and find the y1 value for the specified x value. Remember that no regression should be done w
The marketing manager of a large supermarket chain would like to use shelf space to predict the sales of pet food. A random sample of 12 equal-sized stores is selected, with the following results (see attachment called PetFood). A. Construct a scatter plot. For these data b0 = 145 and b1 = 7.4 B. Interpret the meaning of th
See the attached file. The regression analysis below relates U.S. annual energy consumption in trillions of BTUs to the independent variable "U.S. Gross Domestic Product (GDP) in trillions of dollars." Which of the following statements is true? Energy Consumption and GDP Source * The y-intercept of the regr
The regression analysis below relates US annual energy consumption in trillions of BTUs to the independent variable "US Gross Domestic Product (GDP) in trillions of dollars." Which of the following is the lowest level at which the independent variable is significant? Energy Consumption and GDP Source 0.94 0.10 0.05
Assume your research staff used regression analysis to estimate the industry demand curve for Product X. Qx = 10,000 - 100 Px + 0.5 Y - 1000 r (3,000) (20) (0.3) (105) Where Qx is the quantity demanded of Product X, Px is the price of X, Y is income, and r is the prime interest rate (given in decimals, e.g., 0.02 or 0
A medical researcher found a significant relationship among a person's age x1, cholesterol level x2, sodium level of the blood x3, and systolic blood pressure y. The regression eqauation is y1 = 97.7 + 0.691x1 + 219x2 - 299x3. Predict the systolic blood pressure of a person who is 35 years old and has a cholesterol level of 194
The following readings were taken in a laboratory experiment: x | 0 | 5 | 10 | 15 | ----------------------------------------- y | 3000 | 3501 | 4022 | 4525 | Determine the equation of the form y = mx + b that fits the data in a least squares sense. (1) y = 101.92x + 2997.6 (2) y = x + 3000
Resource: Ch. 12-14 of Applied Statistics in Business and Economics Prepare answers to the following assignments: Exercise 14.6 - Time Series Analysis Given the following data on Asian and European Share of U.S. Light Truck Sales(1990-2003): Year t Percent 1990 1 16.4 1991 2 17.1 1992 3 14.3 1993 4 13.7 1994 5 14.2 19
Develop a regression model to predict selling price based on the square footage and number of bedrooms
SELLING SQUARE AGE PRICE($) FOOTAGE BEDROOMS (YEARS) 64,000 1,670 2 30 59,000 1,339 2 25 61,500 1,712 3 30 79,000 1,840 3 40 87,500 2,300 3 18 92,500 2,234 3 30 95,000 2,311 3 19 113,000 2,377 3 7 115,000 2,736 4 10 138,000 2,500 3 1 142,500 2,500 4
Correlation & Regression Analysis Do heavier cars use more gasoline? If so, can we predict the mileage rating of a car given its weight? Suppose 8 cars were randomly chosen and their weights (in hundreds of pounds) and mileage rating (mpg) are recorded. Weight (x) MPG (y) 27 30 44 19 32 24 47 13 23 29 40 17 34 21 5
Provide some practical examples from work experience where regression models might be used.
1. Find the equation of the regression line for the given data. Predict the value of Y when X=-2? Predict the value of Y when X = 4? 2. The data below are the final exam scores of 10 randomly selected statistics students and the number of hours they studied for the exam. Find the equation of the regression line for the given
1. The data for this problem give the infant mortality rate (per 1000 live births) in the United States for the period 1960-1979. (a) Generate a scatterplot for the data in R. Does the plot make sense? (b) Find the estimated regression equation using R, and give the units and real-world interpretations of the regression co
Estimate a linear demand function for the Sunshine Valley brand by calculating the simple regression of units sold (SVE) on weekly average price (SVAVPR). Include the following: a. Your regression output. Note: it is unnecessary to include a listing of the data and a listing of the residuals. On the output mark the total var
Consider the following time series data representing quarterly sales of dishwashers at Big Boys Appliances over the past two years: Time Sales 2010 Quarter 1 20 2010 Quarter 2 85 2010 Quarter 3 64 2010 Quarter 4 30 2011 Quarter 1 70 2011 Quarter 2 125 2011 Quarter 3 105 2011 Quarter 4 90 The scatter plot of the da
Suppose you are given data from a survey showing the IQ of each person interviewed and the IQ of his or her mother. That is all the information you have. Your boss has asked you to put together a report showing the relationship between these two variables. What could you present and why?
Plots should be done in R, and data set is loaded through R. Please see attachment.