Reference no: EM133076756
Directions: Consider the following scenario: You have been awarded a contract to analyze sales data for a snack food company. They have introduced a new flavor of potato chips (crisps). As part of your analysis, you will need to conduct a hypothesis test on the results of a simple linear regression to determine if there is a relationship between price and amount of product sold. Here is the data you need to analyze:
Price per Bag of Crisps
|
Number of Truck Loads Sold
|
$2.00
|
14
|
$1.90
|
18
|
$1.75
|
24
|
$1.50
|
30
|
$1.25
|
35
|
$1.00
|
41
|
$0.90
|
46
|
$0.75
|
52
|
$0.60
|
57
|
$0.50
|
64
|
Part 1: Set up a hypothesis test (using all six steps) and then conduct the test. You can assume that the data is okay to run a simple linear regression model. So, the first step in the test is already done!
1. Choose the right test.
We will do a simple linear regression. (DONE!)
2. Write down your hypothesis.
The hypothesis is our idea. So, we can formally state it as:
Sales by the truckload will be predicted by ________________________________.
3. Decide on your risk of being wrong.
Our statistical software automatically computes this as equal to 0.05, and this is a standard for academic studies. We'll stick with that. (DONE!)
4. Run the statistical analysis and get the initial results.
We will need to use some statistical software to do this. Click on the link and enter the list of X (price per bag of chips) and Y (number of truckloads sold) values on the screen.
Once you do that, take a look at the output.
5. Figure out the probability if you are right or wrong.
The chance that our idea is wrong given this data is the probability value, which has been abbreviated here as P Value. The value is _________.
6. Decide whether your idea is supported by the data and test
The software tells us that the results are either significant or not significant on the "Deviation from horizontal?" line. Are your results significant?
How well did the number of days visiting the coffee shop predict the sales? It explained about _____% of the variation in sales, according to the R square calculation. Is this a good result in your opinion? Why or why not?
Part 2: Let's suppose a manager wanted to raise price to $2.25 a bag. Take a look at the graph the calculator generated. If you could extend the line up to $2.25, can you predict about how many truckloads would be sold?
Part 3: What would happen if a very similar flavor from another company came on the market and was a good substitute for the chips? Would consumers be more or less sensitive to the price of your product?
Calculate the inventory at the end of year
: At the end of year two, Conte's inventory is $943,000 in terms of a price level of 115 which exists at the end of year two. Calculate the inventory at the end
|
What is the present worth in year
: Wrangler Western has some of its jeans stone- washed under a contract with independent U.S. Garment Corp. If U.S. Garment's operating cost per machine is $22,00
|
What monetary policy would you advise the rba
: Suppose that inflation moves above the Reserve Bank of Australia's (RBA) target rate. Required
|
What is the proper per unit inventory price for product Z
: Given the acquisition cost of product Z is $64, the net realizable value for product Z is $58, What is the proper per unit inventory price for product Z
|
Good substitute for the chips
: Consider the following scenario: You have been awarded a contract to analyze sales data for a snack food company. They have introduced a new flavor
|
Determine value of the ending inventory of finished goods
: Final finished goods inventory 600 units. Under the variable cost method, determine the value of the ending inventory of finished goods
|
Discuss how you felt about the assessment itself
: Now that you have taken the Graphic Literacy Assessment, it is time to discuss its importance while attending college and in the workplace.
|
How many hours of labor should the firm hire
: A firm's production function is Q = 60K^1/3 L^1/2. The firm purchased 27 machines for $50,000 and won't be able to obtain any more machines.
|
What is the minimum cost the flour mill incurs
: A flour millmillflour flour millGrade I: 200kgGrade II: 200kgGrade III: 300kg has two processing plants, P1 and P2, in Victoria. The operates 5 days a week. The
|