Peoria best coffee house extra credit raw

Assignment Help Basic Computer Science
Reference no: EM13920286

Peoria's Best Coffee House
Spring 2015 Extra Credit Question
There is a maximum of 10 possible points.

NOTE: This question uses the Excel file titled Peoria's Best Coffee House Extra Credit Raw Data 2015.

The Backstory

Bob Roaster, the vice president for sales at Peoria's Best Coffee Houses (located in suburban Prescott Florida) is considering expanding this company's chain of coffee houses to Tallahassee. But before he can commit to opening one or two stores in the state capital, he needs to figure out what size stores he might open and how much could they make in revenue per week. He wanted to ask his friend Marvin Bloomy at PC (Prescott College) for help, but old Marvin just left on a 4-week trip to Alaska to see the "sights and to commune with bears" (whatever that means) and is out of touch. So you will have to help him out.

Use StatTools for this extra credit. You will be doing a variety of statistical tests to determine how these variables compare, and a multiple regression using weekly sales as the dependent variable and store size, college nearby and drive thru as the independent variables. Refer to the chats, textbook and/or PowerPoints on how to do and analyze this data and to use the results of the regression to predict the best type of coffeehouses Bob should build in Tallahassee and where they should be located.

Remember to add the variables by first using the Data Set Manager, and then calculate the following statistical tests. Be sure to explain them as you would in any professional reports. The report is to be presented to Bob Roaster from you as his professional statistician. (Lucky you!)

NOTE: The report, in the form of a mini report is to be in a single Word document submitted along with the Excel file that you used to calculate your answers. The date due is determined by the weekly/monthly calendar for your section.

1. Create a one variable summary of all 4 data elements and then analyze it.
a. What does it show you about the regression to follow? Be specific. Hint: Look at the mean versus the median and the skewness versus the kurtosis, what do they tell you about the 4 variables?

b. What other things can you learn about the data provided in the one variable summary?

2. Create histograms for weekly sales and size, (put a checkmark before both and they come out on the same output).

a. What do they show you about the data?

3. Create a box and whisker plot for both sales and size, what do they show you about the data?
a. Are there outliers in the data?

b. If so do you retain the outliers or delete them, and why?

4. Do a correlation on all 4 variables (StatTools/Summary Statistics/Correlation and Covariance/Correlation/Entries below the Diagonal).

a. Which of the variables has the greatest impact on sales?
b. Which of the variables has the least impact on sales?

c. What else can you determine from the correlation?

5. Create a multiple regression with the weekly sales as the dependent variable and the other 3 as the independent variables.
a. Discuss the r-square value for these results. How much of the variation has NOT been predicted by the regression?
i. What additional information would you want to have to increase the predictive validity of the data? Be specific.
b. Are the results sufficiently high to use for prediction?
i. Why or why not?
c. Is the "F" value significant or not?

i. What does this "p-value" mean?

6. Compare the residual statistics generated by the software - what do they tell you about the residuals in this case?

7. Predict what the weekly sales would be for the following information of 3 typical coffeehouses(using the coefficients from this sample) :
Table 1
Store 1 Store 2 Store 3
Store Size 750 955 1150
College yes yes no
Drive Thru no yes no
Estimated Weekly Sales

8. Based on this data what type of coffeehouses should Bob construct in Tallahassee and where should they be built? Be as specific as you want but answer the question.

NOTE: Attach your Excel file to this document that shows that you have completed this analysis of the data. Points will not be given unless this Excel file is attached as an attachment along with your answers.

Reference no: EM13920286

Questions Cloud

Formula for calculating daily recommended calories : The application has the formula for calculating daily recommended calories and the calculation is based on the patient's personal data and it varies according to the patient's gender. Here are the formulas
Produce the original budget and a revised budget allowing : A company produces Widgets and Splodgets which are fairly standardised products. Produce the original budget and a revised budget allowing for controllable factors in a suitable format.
Creating a normobaric hypoxic environment : In his paper on altitude simulation, Daniel found one source that explained that "creating a simulated altitude can be accomplished through creating a normobaric hypoxic environment. "  In his paper, Daniel uses the phrase "normobaric hypoxic envi..
Statements of the rules of debit : 1) Which of the following entries would be used to record the billing of fees earned? 2) If total liabilities are $1,000 and total assets are $8,000, owner's equity must be:
Peoria best coffee house extra credit raw : Bob Roaster, the vice president for sales at Peoria's Best Coffee Houses (located in suburban Prescott Florida) is considering expanding this company's chain of coffee houses to Tallahassee. But before he can commit to opening one or two stores i..
Identify each of the events as an asset source : Identify each of the events as an asset source, use, or exchange transaction.
Correct syntax of a common programming language : Identify and use the correct syntax of a common programming language (Java) - describe program functionality based on analysis of a given program and recall and use typical programming constructs to analyse, design and implement simple software solut..
What items need to measured to substantiate improved process : In your paper, make sure to include a description of the improved process and a "To Be" flow chart. Determine what items need to be measured to substantiate the improved process, the data required to measure improvement, and the upper and lower co..
Define lead, lag, and match strategy for capacity planning : Recommend a better strategy for the Manychip's production strategy, outlining the advantages of your proposal. Should they change from the lead strategy or not?

Reviews

Write a Review

Basic Computer Science Questions & Answers

  Identifies the cost of computer

identifies the cost of computer components to configure a computer system (including all peripheral devices where needed) for use in one of the following four situations:

  Input devices

Compare how the gestures data is generated and represented for interpretation in each of the following input devices. In your comparison, consider the data formats (radio waves, electrical signal, sound, etc.), device drivers, operating systems suppo..

  Cores on computer systems

Assignment : Cores on Computer Systems:  Differentiate between multiprocessor systems and many-core systems in terms of power efficiency, cost benefit analysis, instructions processing efficiency, and packaging form factors.

  Prepare an annual budget in an excel spreadsheet

Prepare working solutions in Excel that will manage the annual budget

  Write a research paper in relation to a software design

Research paper in relation to a Software Design related topic

  Describe the forest, domain, ou, and trust configuration

Describe the forest, domain, OU, and trust configuration for Bluesky. Include a chart or diagram of the current configuration. Currently Bluesky has a single domain and default OU structure.

  Construct a truth table for the boolean expression

Construct a truth table for the Boolean expressions ABC + A'B'C' ABC + AB'C' + A'B'C' A(BC' + B'C)

  Evaluate the cost of materials

Evaluate the cost of materials

  The marie simulator

Depending on how comfortable you are with using the MARIE simulator after reading

  What is the main advantage of using master pages

What is the main advantage of using master pages. Explain the purpose and advantage of using styles.

  Describe the three fundamental models of distributed systems

Explain the two approaches to packet delivery by the network layer in Distributed Systems. Describe the three fundamental models of Distributed Systems

  Distinguish between caching and buffering

Distinguish between caching and buffering The failure model defines the ways in which failure may occur in order to provide an understanding of the effects of failure. Give one type of failure with a brief description of the failure

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd