Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Using the franchise data for New Era Organic Foods Stores, to produce a model to predict the annual net sales from the other variables. Please

  1. Using the franchise data for New Era Organic Foods Stores, to produce a model to predict the annual net sales from the other variables. Please discuss the significance of the model and the predictors. Make any additional observations that you consider pertinent regarding the model you run.

X1 X2 X3 X4 X5 X6 The data (X1, X2, X3, X4, X5, X6) are for each franchise store.
231 3 294 8.199999809 8.199999809 11 X1 = annual net sales/$1000
156 2.200000048 232 6.900000095 4.099999905 12 X2 = number sq. ft./1000
10 0.5 149 3 4.300000191 15 X3 = inventory/$1000
519 5.5 600 12 16.10000038 1 X4 = amount spent on advertizing/$1000
437 4.400000095 567 10.60000038 14.10000038 5 X5 = size of sales district/1000 families
487 4.800000191 571 11.80000019 12.69999981 4 X6 = number of competing stores in distric
299 3.099999905 512 8.1 10.10000038 10
195 2.5 347 7.699999809 8.4 12
20 1.200000048 212 3.299999952 2.099999905 15
68 0.600000024 102 4.900000095 4.699999809 8
570 5.400000095 788 17.39999962 12.30000019 1
428 4.199999809 577 10.5 14 7
464 4.699999809 535 11.30000019 15 3
15 0.600000024 163 2.5 2.5 14
65 1.200000048 168 4.699999809 3.299999952 11
98 1.600000024 151 4.599999905 2.700000048 10
398 4.300000191 342 5.5 16 4
161 2.599999905 196 7.199999809 6.300000191 13
397 3.799999952 453 10.39999962 13.89999962 7
497 5.300000191 518 11.5 16.29999924 1
528 5.599999905 615 12.30000019 16 0
99 0.800000012 278 2.799999952 6.5 14
0.5 1.100000024 142 3.099999905 1.600000024 12
347 3.599999905 461 9.6 11.30000019 6
341 3.5 382 9.800000191 11.5 5
507 5.099999905 590 12 15.69999981 0
400 8.6 517 7 12 8

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

Project management

Authors: Harvey maylor

4th Edition

027370432X, 978-0273704324

More Books

Students also viewed these General Management questions