Question: I ran a regression for the following: A random sample of 15 pizza outlets were selected from the population of outlets of a large national

I ran a regression for the following: A random sample of 15 pizza outlets were selected from the population of outlets of a large national retail pizza maker. Data on monthly sales (number of pizzas) and advertising expenses per outlet are in the file "pizza data.xls". Using either Excel or StatTools, run a regression of sales as Y on ads as X. Assume the validity of the regression model (L,H,I,N) for the following questions.

But I don't know how to use the data to determine the following. Can you tell me what I need to do to solve this?

1. A new outlet is being planned with an allocated budget of $50,000 per month for advertising. Estimate the monthly sales (number of pizzas) of this outlet.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

asking about question 1. I have also included the excel data for the problem. A random sample of 15 pizza outlets were selected from the population of outlets of a large national retail pizza maker....

Suppose all outlets will spend $50,000 per month on advertising and maintain an average price of $10.00. Estimate the mean monthly sales among all outlets. By how much, plus or minus, do you expect...

Management Science Journal - Please read and summarize the attached journal entry. The summary should discuss the main finding(s), the methods used, the implications of the work, and, importantly,...

Use data in worksheet named Q1-4 to answer questions 1 4. Assume the sample data was published in a business magazine. 1) Which of the following is true about the data? A. Class is qualitative and...

ASSUMPTION UNIVERSITY GRADUATE SCHOOL OF eLEARNING Master of Science in Management SCIT Building 9th floor, 88 Moo 8 Bangna-Trad Km 26, Bang Sao Thong, Samutprakarn 10540 Thailand Tel: + 66 2 7232944...

Set Student Name: 1. Answer true or false for each part, and if false, explain your answer. a. The point estimate for the population mean, , of an x distribution is x-bar, computed from a random...

MS1023 Business Statistics with Computer Applications MS1023 Business Statistics w/Comp Apps I Homework #3 - Use Red Par Score Form Chp. 7: Questions 1-50 1. Kristen Ashford purchased the subscribers...

Instuctor's Annotated Edition TENTH EDITION Understandable Statistics Concepts and Methods Charles Henry Brase Regis University Corrinne Pellillo Brase Arapahoe Community College Australia Brazil...

Set Student Name: 1. Describe the relationship between two variables that have a correlation coefficient value: a. Near -1 b. Near 0 c. Near 1 2. Data was collected where a weightlifter was asked to...

Instuctor's Annotated Edition TENTH EDITION Understandable Statistics Concepts and Methods Charles Henry Brase Regis University Corrinne Pellillo Brase Arapahoe Community College Australia Brazil...

The production budget is the first component of the operating budget True False

Until a few years ago, there were not many black faculty members at Wilson High School, in a suburb of Washington, D.C. Because of a court decision and of other factors, the situation began...

A baseless and usually negative precancer belief opinion or judgment toward a group of people or single person because of their membership in a certain group

A company is preparing completing their Cash Budget. The following data has been prepared for cash receipts and payments. January February March Cash receipts $1,061,200 $1,182,400 $1,091,700 Cash...