Before you conduct regression analyses, please convert all your data to natural logs indluding the dependent variable. This helps convert regression coefficients to elasticities. This makes it easy for you to calculate which variables need to be changed by how much to meet the sales growth target of 10%.

Since natural logs do not exist for negative values, exclude any variable that has negative values from your multiple natural log regressions.

You can conduct regression analyses on the following variables.

Sales/square feet as dependent variable. Or instead you can pick sales growth as your dependent variable.

Independent variables can include:

Seats inside, seats-patio, median income, median age, bachelors degree, average monthly salad sales, average monthly rice-krispy sales, alcohol sales, fountain drink sales etc.

If one were to find a strong relationship between the dependent variable and and some independent variables, then the recommendation would be to exploit those relationships to attain business objectives. Explain how the percentage of protein sales relates to sales growth over previous years (%).

Show step-by-step using megastat.

ChgServTime

0.27

1.80

1.15

0.15

0.77

1.38

0.45

-0.02

1.52

0.20

0.38

0.53

0.63

0.03

0.68

-0.30

0.07

1.15

0.12

0.67

0.47

-0.32

0.78

1.07

0.43

1.00

0.48

0.72

0.52

-0.87

0.50

1.18

0.08

0.90

0.07

0.72

1.40

2.03

1.82

0.62

1.18

-0.15

0.03

0.45

0.63

2.22

0.07

1.90

0.90

0.00

2.48

0.92

0.32

2.05

0.93

2.02

0.60

0.90

1.50

0.27

0.32

2.55

1.03

1.43

0.70

0.90

2.58

1.15

2.32

2.47

1.18

0.13

-0.02

0.35