Create and interpret scatterplots of Price vs SQFeet and Price vs Age 2. Run the best subsets procedure. Identify the best model to use and why. 3. Run the regression procedure using the model you chose in #2 a. Identify the regression equation. b. Interpret all c
Create and interpret scatterplots of Price vs SQFeet and Price vs Age 2. Run the best subsets procedure. Identify the best model to use and why. 3. Run the regression procedure using the model you chose in #2 a. Identify the regression equation. b. Interpret all c
MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
Related questions
Question
Need Help!!
Problem 1 (You are trying to predict Price.)
Note: Mtn View=1 if there is a mountain view, 0 otherwise. The rest of the variables
should be self explanatory.
1. Create and interpret scatterplots of Price vs SQFeet and Price vs Age
2. Run the best subsets procedure. Identify the best model to use and why.
3. Run the regression procedure using the model you chose in #2
a. Identify the regression equation.
b. Interpret all coefficients
c. Identify and interpret the R-Square
For parts d-e, use the p-value value approach for each test (use .05 for
significance level)
d. Perform an F Test for overall significance of the model
e. Perform a T test for slope for the age variable
f. Find a 95% confidence interval for the slope of the SqFeet variable
g. Create a prediction, CI, and PI for 1 new set of x values (any valid
numbers you want), and interpret each.
h. Run the residual plots and indicate if they show any problems with
the model.
4. Discuss how good the model is for predicting home prices.
Note: Mtn View=1 if there is a mountain view, 0 otherwise. The rest of the variables
should be self explanatory.
1. Create and interpret scatterplots of Price vs SQFeet and Price vs Age
2. Run the best subsets procedure. Identify the best model to use and why.
3. Run the regression procedure using the model you chose in #2
a. Identify the regression equation.
b. Interpret all coefficients
c. Identify and interpret the R-Square
For parts d-e, use the p-value value approach for each test (use .05 for
significance level)
d. Perform an F Test for overall significance of the model
e. Perform a T test for slope for the age variable
f. Find a 95% confidence interval for the slope of the SqFeet variable
g. Create a prediction, CI, and PI for 1 new set of x values (any valid
numbers you want), and interpret each.
h. Run the residual plots and indicate if they show any problems with
the model.
4. Discuss how good the model is for predicting home prices.
Problem 2 (This was given to me by the assessment coordinator and needs to be
collected for AACSB accrediting).
Q1: Pat Jones is the general manager at Denny’s Muffler, which has 3 locations and
27 employees. Currently, the office manager at 3 stores put input their weekly sales
results into a spreadsheet and e-mail that spreadsheet to Pat on Friday by noon.
Each week, Pat handles between 120 to 350 records of sales data, and another 100
to 300 records of customer data. Pat would be like to keep track of weekly sales,
which customers are associated with each sale, the parts used for each sale, what
work was done for each customer at each sale, and which parts were used for each
sale. If Pat wants to improve his efficiency and effectiveness, which of the following
applications would be the best for collecting and storing Pat’s data?
1) Excel
2) SAP
3) Access
4) Minitab
5) Teams
6) MySQL
collected for AACSB accrediting).
Q1: Pat Jones is the general manager at Denny’s Muffler, which has 3 locations and
27 employees. Currently, the office manager at 3 stores put input their weekly sales
results into a spreadsheet and e-mail that spreadsheet to Pat on Friday by noon.
Each week, Pat handles between 120 to 350 records of sales data, and another 100
to 300 records of customer data. Pat would be like to keep track of weekly sales,
which customers are associated with each sale, the parts used for each sale, what
work was done for each customer at each sale, and which parts were used for each
sale. If Pat wants to improve his efficiency and effectiveness, which of the following
applications would be the best for collecting and storing Pat’s data?
1) Excel
2) SAP
3) Access
4) Minitab
5) Teams
6) MySQL
Q2: Raj Miller runs an 8-person sales team at a small paper company that has 22
employees and $6,500,000 of revenue per year. Raj needs to give a presentation of
second quarter sales results to company management. As part of the presentation,
Raj would like to create some charts and pivot tables to summarize the quarterly
data.
To be successful at this presentation, which of the following technologies would be
the best choice (or choices) for creating charts and making his in-person
presentation to company management? (Indicate all correct answers)
1) SAP
2) Excel
3) Access
4) Powerpoint
5) Oracle
Q3: Jami is an intern on a sales team at a large insurance company. On the first day
of the internship, Jami is asked to download a list of all of her friends and contacts
from Facebook and upload them to the company database. The team lead explains
"This database keeps track of all of our employees, and well as their customers and
prospects. This makes it really easy to avoid redundant customer interactions, and
also keeps us from cannibalizing customers and business from one another."
Jami is wondering if there are ethical issues she should be concerned about. Do you
think there are ethical issues involved with this situation? If yes- what are those
issues, specifically, and how would you advise Jami?
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!
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 2 images
Recommended textbooks for you
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman