A manager believes that sales (S) (in $) is a function of the amount of work (H) and commission paid (C). Given data for both variables, the manager ran a regression analysis with the output shown here. Coefficients t Stat P-value Intercept 100 1.80 0.1008 Work Hours -2.20 0.01 Commission 7 2.66 0.04 Write down the regression model/ equation between the dependent and independent variables, and find the amount of sales for H=2 and c=5

A manager believes that sales (S) (in $) is a function of the amount of work (H) and commission paid (C). Given data for both variables, the manager ran a regression analysis with the output shown here. Coefficients t Stat P-value Intercept 100 1.80 0.1008 Work Hours -2.20 0.01 Commission 7 2.66 0.04 Write down the regression model/ equation between the dependent and independent variables, and find the amount of sales for H=2 and c=5

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Related questions

Q: The following data is to be used to construct a regression model: X 5 7 4 15 12 9 Y 8 9 12 26 16 13…

A: XY587941215261216913

Q: The following table gives the data for the grades on the midterm exam and the grades on the final…

A: Grades on Midterm and Final Exams Grades on Midterm 65 55 70 86 74 82 65 75 77 73 Grades on…

Q: A sales manager collected the following data on x = years of experience and y = annual sales…

A: Givenx=years of experiencey=annual sales($1,000s) salesperson x y 1 1 80 2 3 97 3 4 97 4…

Q: Suppose the equation of the regression line for the number of emails a person recieves at a…

A: we want to find value for 16 emails will they received

Q: An instructor asked a random sample of eight students to record their study times in a beginning…

A: A random sample of eight students to record their study times in a beginning calculus course

Q: The following table shows the approximate amount of trash produced in an industrialized country from…

A: The given data is shown below. Year Million Tons 1980 154 1990 204 2000 218 Here, x…

Q: Use the model to predict the amount of money spent by a customer who spends 11 minutes at the store.…

A: The regression equation is Dollar Spent=4.75+3.23*Time spent When time spent is 11 minutes then…

Q: The correct interpretation of the slope is that for each additional Data were collected on monthly…

A: The predicted sales revenue for a month in which $1,000 was spent on advertising is obtained…

Q: The table shows the U.S. Bureau of Census population data for St. Louis, Missouri. t= years since…

Q: With the following data find the regression equation for the prediction of the number hours spent on…

A: The given data set is: Friends(x) Social(y) x2 y2 xy 22 3 484 9 66 16…

Q: Consider the following data set. x 1 2 3 4 5 y 2.4 2 1.6 1.5 1.4 (a) Plot the data. (b) Find…

A: X Y 1 2.4 2 2 3 1.6 4 1.5 5 1.4

Q: The following table shows the amount of a chemical substance over time. Time (hours) Amount (mg). 37…

A: Find Regression line equations from the following data, also Estimate y when x = 24 X Y 25 37…

Q: The table below shows the number of millions of internet users in a particular region. Let x…

Q: The following regression model shows the relationship between selling price of a house(y) and the…

A: (a) Regression line for the first Regression line for the second

Q: Louis Katz, a cost accountant at Papalote Plastics, Inc. (PPI), is analyzing the manufacturing costs…

A: In this case, the independent variable is the production lot size (x) and the dependent variable is…

Q: Use the scatterplot of Vehicle Registrations below to answer the questions Vehicle Registrations in…

A: Given, equation of regression line is- y(x) =…

Q: For nine months, Joan observes the average daily gas consumption for her house and the corresponding…

A: Note: Since we only answer up to 3 sub-parts, we'll answer the first 3. Please resubmit the…

Q: The following table compares the length of a rhinoceros horn (in inches) to its body length (in…

A: From given data, x Y X*X X*Y 34 111 3774 1156 37 114 4218 1369 40 124 4960 1600 43 134…

Q: A lot of data about the Ipod Touch has been collected since it came out. Below is a table of data…

Q: X1 2 3 5 6 7 8 X2 3 4 6 8 9 10 Y 4 5 8 10 11 12

A: Solution:-> Y=c(4,5,8,10,11,12)> X1=c(2,3,5,6,7,8)> X2=c(3,4,6,8,9,10)>…

Q: Refer to the data set: Part a: Make a scatter plot and determine which type of model best fits the…

A: a) Use the excel spreadsheet to find the scatterplot for the given data. From the above figure it…

Q: The following tables show five people’s occupational prestige scores (OPS) and their income (in…

A: Step 1:The OPS occupational prestige scores(X) and Income(Y) of five people is shown.We need to find…

Q: d dala, Odvlo Satistacuion as i anert that fnas ule lar Categoncal able department has muniple…

A: Modify the data as follows: Department Satisfaction X1 X2 X3 X4 X5 X6 Management 9 0 1 0 0 0 1…

Q: Find the equation of the regression line for the minutes the actor appeared shirtless in a film and…

A: Data…

Q: Use the scatterplot of Vehicle Registrations below to answer the questions Vehicle Registrations in…

Q: For each of the following data sets: plot the data, determine the regression equation, and add the…

Q: Find the slope (b1) for the regression equation for the following values. Round to 3 decimal places.

A: Given that X Y X \cdot YX⋅Y X^2X2 Y^2Y2 33 180 5940 1089 32400 25 170 4250 625 28900…

Q: What is the interpretation of the intercept regression coefficient in a regression model? A. The…

A: The question is asking about the interpretation of the intercept in a regression model. In a simple…

Q: Using the regression to model annual income, a variable for years of education has a slope = 2000.…

A: From the given data,we can frame the equation as follows Y = 2000X + C Where Y is the annual income…

Concept explainers

Correlation

Correlation defines a relationship between two independent variables. It tells the degree to which variables move in relation to each other. When two sets of data are related to each other, there is a correlation between them.

Linear Correlation

A correlation is used to determine the relationships between numerical and categorical variables. In other words, it is an indicator of how things are connected to one another. The correlation analysis is the study of how variables are related.

Regression Analysis

Regression analysis is a statistical method in which it estimates the relationship between a dependent variable and one or more independent variable. In simple terms dependent variable is called as outcome variable and independent variable is called as predictors. Regression analysis is one of the methods to find the trends in data. The independent variable used in Regression analysis is named Predictor variable. It offers data of an associated dependent variable regarding a particular outcome.

Question

A manager believes that sales (S) (in $) is a function of the amount of work (H) and commission paid (C). Given
data for both variables, the manager ran a regression analysis with the output shown here.
Coefficients
t Stat
P-value
Intercept
100
1.80
0.1008
Work Hours
-2.20
0.01
Commission
2.66
0.04
Write down the regression model/ equation between the dependent and independent variables, and find the
amount of sales for H=2 and c=5
I
X2
x2
三三三
of
1.

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 2 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

$Correlation, Regression, and Association$

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.

Similar questions

An instructor asked a random sample of eight students to record their study times at the beginning of a course. She then made a table for total hours studied (x) over 2 weeks and test score (y) at the end of the 2 weeks. The table is given below. Complete parts (a) through (f). x 10 13 10 18 6 15 16 21 y 93 79 81 74 85 81 85 80 a. Find the regression equation for the data points. b. Graph the regresson equation c. Describe the apparent relationship between the two variables. d. Identify the predictor and response variables. e. Identify outliers and potential influential observations. f.Predict the score for a student that studies for 17 hours.
Part a: Make a scatter plot and determine which type of model best fits the data.Part b: Find the regression equation.Part c: Use the equation from Part b to determine y when x = 0.25
Answer d,e and f
Regression analysis was applied between $ sales (y) and $ advertising (x) across all the branches of a major international corporation. The following regression function was obtained. ý: - 5000 + 7.25x If the advertising budgets of two branches of the corporation differ by $20,000, then what will be the predicted difference in their sales? O $217,500 $222,500 O $145000 O none of the above
A statistical program is recommended. The owner of Showtime Movie Theaters, Inc., would like to predict weekly gross revenue as a function of advertising expenditures. Historical data for a sample of eight weeks follow. Weekly Television Gross Newspaper Advertising Advertising ($1,000s) ($1,000s) Revenue ($1,000s) 96 5.0 1.5 90 2.0 2.0 95 4.0 1.5 92 2.5 2.5 95 3.0 3.3 94 3.5 2.3 94 2.5 4.2 94 3.0 2.5 1 (a) Develop an estimated regression equation with the amount of television advertising as the independent variable. (Round your numerical values to two decimal places. Let x₁ represent the amount of television advertising in $1,000s and y represent the weekly gross revenue in $1,000s.) y = 88.64 + 1.60x1 X (b) Develop an estimated regression equation with both television advertising and newspaper advertising as the independent variables. (Round your numerical values to two decimal places. Let x₁ represent the amount of television advertising in $1,000s, x₂ represent the amount of…
Choose the correct answer of each number. 1. An analyst hired by the multinational company to study the sales data of its more than 75 stores worldwide. Used regression analysis to predict $ sales (y) by using $ advertising (x1) and $ salary of sales representatives (x2) across all the branches. You obtained the following regression function: y = 7800 + 8.5x1-1.6x2. If the advertising budgets of one of the branches of the corporation is now $45,000 (which is 10% more than before) and the salary of sales representatives is now $8,500 (which is 20% less than before), then the predicted sales before in that branch is a. $417,750 b. $341,250 c. $376,700 d. $335,6502. An analyst hired by the multinational company to study the sales data of its more than 75 stores worldwide. Used regression analysis to predict $ sales (y) by using $ advertising (x1) and $ salary of sales representatives (x2) across all the branches. You obtained the following regression function: y = 7800 + 8.5x1-1.6x2. If…
Perform a linear regression analysis on the following data and determine the "a" coefficient (i.e., slope): Y 4.99 22.19 1.96 9.89 2.98 11 9 40.46 4.04 18.93 6.06 25 0.88 0.19 8.02 34.02 6.97 28.03
Use Excel to Run the Regressions:1. Wage and Age: Do you think a worker’s wage is related to his/her age? It is expected that wagesincrease with age up to certain age, after that wages go down. The “Wage Quadratic Data” fileposted contains data on the hourly wage (in $) for construction workers, workers’ ageand whether the worker has a bachelor’s degree or not (Graduate equals 1 if the worker has abachelor’s degree and 0 otherwise). Use the data file to answer the following questions:A) Build a model to predict the hourly wage of construction workers based on their education andage.B) Use the model to predict the hourly wage for a college graduate construction worker if his/herage is 30, 50, and 70c) Based on your model, calculate the age at which the hourly wage for construction workers ismaximized.
The percentage of adults who smoke in America is given below. Year America 1970 37.4 mon n 1980 33.2 1990 25.3 2000 23.1 2010 19.4 a) Write the linear regression model for A(x), representing the percentage of adult smokers in America x years since 1970. [Use your calculator OR Desmos to find the equation, Round coefficients to the nearest 100"] b) What is the slope of A(x)? Explain its meaning. c) Solve A(x) = 15. Show your work. Explain the meaning of your answer. d) Suppose in 2005, there were approximately 200 million adults in America. Use your model to estimate how many were smokers. Show how you get your answer.
The sales of a company (in million dollars) for each year shown in the table below (25)X(year) 2005 2006 2007 2008 2009Y (sales) 12 19 39 37 45a. Find the regression line of the data. Draw the inference about the dataset.b. Use the regression line as a model to estimate the sales of the company in 2012.
For the data in the table, find the regression equation. Here, x gives the number of years of experience for nurses, and y is their annual salary (in $1000's). Round the slope and y-intercept to two decimals, then use your equation to answer the questions below. Years of Salary Experience ($1000's) 40 4 42 43 45 10 46 13 52 15 53 17 56 21 58 22 60 a. What is the expected salary (in $1000's) for a nurse with no work experience? b. By what amount (in $1000's) does an extra year of experience boost the annual salary?
Find the intercept (b0) for the regression equation for the following values. Round to 3 decimal places. Intercept xi yi 33 180 25 170 50 200 65 172 57 160 27 165