Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I have attached a screen shot of the questions. Please I need help so help me G + m Assignment 13e USE u = 0.05

I have attached a screen shot of the questions. Please I need help so help me

image text in transcribed
G + m Assignment 13e USE u = 0.05 1. A distributor of frozen desert pies wants to evaluate factors thought to influence demand (i.e. number of pies sold). He collects 10 weeks of data on sales volumne, the price, and how much is spent on advertising. .\\ Advertising 1 2 3 4 5 6 7 8 9 9 a a) Considering the model where only the price is used to predict the sales volume, test the model to determine if the model is valid. Be sure to state you null and alternative hypotheses. What is your pvalue? What is your conclusion? As a part of this assignment, submit a copy of your Excel file with this p-value clearly labeled. b) Using this same model, test the slope to determine if it is significant. Be sure to state you null and alternative hypotheses. What is your pvalue? What is your conclusion? As a part of this assignment, submit a copy of your Excel file with this p-value clearly labeled. c) What is the value of the Coefficient of Determination? As a part of this assignment, submit a copy of your Excel file with this value clearly labeled. d) What is the value of the standard error of the estimate? As a part 01 this assignment, submit a copy of your Excel file with this value clearly labeled. 2. Now consider the possibility of using price and advertising to predict the units sold. If you had to pick % variable only, which is a better predictor of the selling price? Why

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Precalculus

Authors: Michael Sullivan

9th edition

321716835, 321716833, 978-0321716835

More Books

Students also viewed these Mathematics questions