Using Excel, create scatter plots and display the regression equations for the following pairs of variables:...

Using Excel, create scatter plots and display the regression equations for the following pairs of variables:
“MedAge” versus “Sales/SqFt”
In your report, include the scatter plots. For each scatter plot, designate the type of relationship observed (increasing/positive, decreasing/negative, or no relationship) and determine what you can conclude from these relationships.

Sales/SqFt

701.97 209.93 364.92 443.04 399.20 264.64 571.59 642.25 461.45 638.82 484.38 581.09 267.71 572.84 586.48 368.73 351.47 458.24 987.12 357.45 405.77 680.80 368.02 303.95 393.90 562.12 494.88 310.07 373.46 235.81 413.08 625.22 274.30 542.62 178.56 375.33 329.09 297.37 323.17 468.84 352.57 380.34 398.12 312.15 452.16 698.64 367.19 431.93 367.06 400.53 414.36 481.11 538.06 330.48 249.93 291.87 517.40 551.58 386.81 427.50 453.94 512.46 345.27 234.04 348.33 348.47 294.95 361.14 467.71 403.78 245.74 339.94 400.82 326.54

MedAge

34.4 41.2 40.3 35.4 31.5 36.3 35.1 37.6 34.9 34.8 36.2 32.2 30.9 37.7 34.3 32.4 32.1 31.4 30.4 33.9 35.6 35.9 33.6 37.9 40.6 37.7 36.4 40.9 35.0 26.4 37.1 30.3 31.3 29.6 32.9 40.7 29.3 37.3 39.8 33.9 35.0 35.0 35.9 33.0 30.9 38.5 40.5 32.1 34.8 38.0 37.0 34.7 36.4 36.8 32.2 34.8 36.7 33.8 34.2 39.0 34.9 39.3 35.6 36.0 41.1 24.7 40.5 32.9 30.3 36.2 32.4 43.5 41.6 31.4

Expert Solution

Following is the scatter plot the given data;

Scatter plot shows a very weak negitive relationship between the variables.

Let Y denote Sales/SqFt and X denote MedAge.

Following is the output of regression analysis generated by excel

SUMMARY OUTPUT

Regression Statistics
Multiple R	0.059787205
R Square	0.00357451
Adjusted R Square	-0.010264733
Standard Error	137.9420885
Observations	74

ANOVA
	df	SS	MS	F	Significance F
Regression	1	4914.708539	4914.708539	0.258287967	0.6128524
Residual	72	1370017.425	19028.01979
Total	73	1374932.133

	Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%
Intercept	499.3391617	156.3353519	3.194025891	0.002082334	187.6903378	810.9879856
MedAge, X	-2.245190974	4.417750666	-0.508220392	0.6128524	-11.05181585	6.561433903

The regression equation is

y' = 499.339 - 2.245x

Following is the scatter plot with regression line:

orchestra answered 1 year ago

Write the reduce the form of the regression line after removing insignificant variables ( using excel)...

Write the reduce the form of the regression line after removing insignificant variables ( using excel) Sales Y Price X Adver X 19.98 14.10 15.19 19.98 18.65 15.19 19.98 18.65 13.87 19.98 18.65 12.83 19.98 18.65 13.16 19.98 18.65 15.19 19.98 18.65 13.92 20.10 18.73 14.42 20.12 18.75 13.83 20.13 18.75 14.50 20.14 18.75 13.87 20.12 18.75 13.64 20.12 13.87 14.31 20.13 14.27 13.85 20.14 18.76 14.20 20.14 18.77 13.64 20.13 13.87 14.33 20.13 14.14 13.14 20.13 18.76 13.81 20.13...

Using a scatter plots describe the relationship between (i) Hwage and Educ and (ii) Hwage and...

Using a scatter plots describe the relationship between (i) Hwage and Educ and (ii) Hwage and Exper. Use Hwage as the Y-variable Hwage Educ Exper Female 9 10 27 0 5.5 12 20 0 3.8 12 4 1 10.5 12 29 1 15 12 40 0 9 16 27 1 9.57 12 5 1 15 14 22 0 11 8 42 0 5 12 14 1 24.98 17 18 0 20.4 17 3 0 25 14 4 0 13.98 14...

For the following problems, construct a scatter plot using excel. After the plot is drawn, analyze...

For the following problems, construct a scatter plot using excel. After the plot is drawn, analyze it to determine which type of relationship, if any, exists. Enter data in the excel worksheet (let’s say in column A you enter x data, in B you enter y data)à Select Data --> CLICK Insert --> Click Scatter --> Click the first case that contains unconnected points -->release the mouse If you choose layout 9, you get the regression equation that can...

Create a scatter plot. What does it indicate? What is the regression equation? Is the equation...

Create a scatter plot. What does it indicate? What is the regression equation? Is the equation significant? How do you know? What is the estimate for Period 13? What is the r2 and what does it signify? Period Sales 1 12 2 13 3 12 4 14 5 13 6 15 7 16 8 14 9 17 10 15 11 17 12 18

Assignment on Multiple Linear Regression The Excel file BankData shows the values of the following variables...

Assignment on Multiple Linear Regression The Excel file BankData shows the values of the following variables for randomly selected 93 employees of a bank. This real data set was used in a court lawsuit against discrimination. Let = starting monthly salary in dollars (SALARY), = years of schooling at the time of hire (EDUCAT), = number of months of previous work experience (EXPER), = number of months that the individual was hired (MONTHS), = dummy variable coded 1 for males...

Which of the following pairs of variables (attributes listed in parentheses) could be analyzed using a...

Which of the following pairs of variables (attributes listed in parentheses) could be analyzed using a chi-square analysis? [hint: consider the level of measurement for each variable] Options: -Race (African American, Hispanic/Latino, White, Other) & Number of Children (0,1, 2, 3, 4, 5, 6+) -Gender (Male, Female) & Depression Score (Measured on a multi-item Likert Scale, Beck Depression Inventory) -Police Officer Rank (Cadet, Officer, Sergeant, Lieutenant, Chief of Police) & Favorite Color (Blue, Green, Red, Yellow) -Marital Status (Single, Married)...

For the following data (a) display the data in a scatter plot, (b) calculate the correlation...

For the following data (a) display the data in a scatter plot, (b) calculate the correlation coefficient r, and (c) make a conclusion about the type of correlation. The ages (in years) of 6 children and the number of words in their vocabulary Age, x 1 2 3 4 5 6 Vocabulary size, y 150 1100 1150 1800 2050 2700 A] The correlation coefficient r is

Make a scatter plot, including the regression line and its equation. Use an appropriate Excel function...

Make a scatter plot, including the regression line and its equation. Use an appropriate Excel function to find the correlation coefficient r. Determine the type of linear relationship, if any. Interpret the slope and y-intercept, if appropriate, in the context of the data. Use an appropriate Excel function and the data to find a predicted(average) selling price for a single- family house measuring 1960 square feet. Does the house that measured 1960 square feet in the sample have a selling...

Java Programing Display any welcome message at the top of the output screen Create following variables:...

Java Programing Display any welcome message at the top of the output screen Create following variables: Price for a cup of coffee (make it adjustable within the program) Number of cups (response from User) Tax Rate in San Diego is 8%. Define 8% as a CONSTANT variable that never changes Payment Method (Cash, Credit Card, Store Credit, Gold) Ask the customer for their first name, and store it as a String object. Ask the customer (by name) how many cups...

a. Use the multiple regression spreadsheet provided in the Excel spreadsheet to do the following: create...

a. Use the multiple regression spreadsheet provided in the Excel spreadsheet to do the following: create a new data set that is a subset of this larger provided data set. The new data set should include the dependent variable (VALUE) and the following independent variables (AGE, LOTSIZE, RMS, MOD KITCH, MOD BATH, AIRCON and FIREPL). b. For this new data set, use the Correlation option of Data Analysis in Excel and produce the correlation matrix associated with the dependent variable...

Question