Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please show me exactly how to enter any formulas into excel. I am very confused and I keep getting errors. Thank you! 6. What does

Please show me exactly how to enter any formulas into excel. I am very confused and I keep getting errors. Thank you! image text in transcribed
image text in transcribed
6. What does the coefficient of each of the statistically significant independent variable mean? (Answer separately for each attribute that is statistically significant) 7. What is the next step of your modeling process? Do the next step and report the results. \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|} \hline CustomerNo & billToState & Profit & Web Orders & WebYN & CoastalState & SunPct & EmpCount & ZipInc & ZipPop \\ \hline U0137343 & MN & 1547.63 & 0 & 0 & 0 & 55 & 50 & 65314 & 30141 \\ \hline U0225537 & IN & 494.07 & 0 & 0 & 0 & 57.66 & 90 & 40822 & 38774 \\ \hline U0138648 & PA & 31.86 & 0 & 0 & 0 & 53.33 & 27 & 70504 & 30031 \\ \hline U0435328 & OH & 91 & 1 & 1 & 0 & 51 & 5 & 60457 & 49067 \\ \hline U0410822 & MA & 13.8 & 0 & 0 & 1 & 55 & 60 & 94049 & 20810 \\ \hline U0154446 & CA & 5677.77 & 0 & 0 & 1 & 71.85 & 40 & 56566 & 39315 \\ \hline U0157062 & OK & 1459.26 & 1 & 1 & 0 & 65 & 0 & 52053 & 47249 \\ \hline U0334044 & SC & 15480 & 0 & 0 & 1 & 62.33 & 60 & 30698 & 38302 \\ \hline U0258145 & MO & 72.96 & 0 & 0 & 0 & 58.25 & 55 & 28000 & 6283 \\ \hline U0407739 & FL & 237.3 & 2 & 1 & 1 & 66.83 & 0 & 88530 & 20975 \\ \hline U0200291 & VA & 360.6 & 0 & 0 & 1 & 60.66 & 0 & 36325 & 7269 \\ \hline U0401751 & MN & 150.95 & 0 & 0 & 0 & 55 & 10 & 36560 & 54296 \\ \hline U0408618 & MD & 1699.44 & 0 & 0 & 1 & 57 & 5 & 43108 & 39086 \\ \hline U0429734 & KY & 1022.63 & 0 & 0 & 0 & 53 & 85 & 41563 & 817 \\ \hline U0413151 & NJ & 392.78 & 0 & 0 & 0 & 56 & 100 & 60487 & 50766 \\ \hline U0251636 & NJ & 0 & 0 & 0 & 0 & 56 & 6 & 99494 & 27264 \\ \hline U0164526 & TN & 354 & 0 & 0 & 0 & 58.25 & 2 & 29979 & 5297 \\ \hline U0386336 & MS & 1630 & 0 & 0 & 1 & 62.5 & 4 & 35586 & 19289 \\ \hline U0343025 & IL & 67.8 & 0 & 0 & 0 & 56.8 & 20 & 44103 & 15688 \\ \hline U0359040 & TX & 261 & 1 & 1 & 1 & 65.21 & 3 & 53199 & 10984 \\ \hline U0122069 & FL & 26.88 & 0 & 0 & 1 & 66.83 & 30 & 48920 & 17910 \\ \hline U0133758 & KY & 779.5 & 0 & 0 & 0 & 53 & 54 & 34795 & 37415 \\ \hline U0261519 & NY & 214 & 0 & 0 & 1 & 50.83 & 12 & 61661 & 6539 \\ \hline U0317495 & MA & -89 & 0 & 0 & 1 & 55 & 35 & 52512 & 56203 \\ \hline U0388052 & TX & 507.5 & 1 & 1 & 1 & 65.21 & 22 & 46995 & 15436 \\ \hline U0422386 & MO & 167.83 & 0 & 0 & 0 & 58.25 & 3 & 28869 & 5065 \\ \hline U0311196 & IL & 332 & 1 & 1 & 0 & 56.8 & 200 & 44798 & 27370 \\ \hline U0203095 & FL & -318.07 & 0 & 0 & 1 & 66.83 & 98 & 40788 & 28752 \\ \hline U0188556 & IL & 426.11 & 1 & 1 & 0 & 56.8 & 3 & 38487 & 76015 \\ \hline U0183475 & IL & 54 & 0 & 0 & 0 & 56.8 & 0 & 67608 & 31513 \\ \hline U0202559 & CA & 118.43 & 0 & 0 & 1 & 71.85 & 0 & 35403 & 40372 \\ \hline U0372255 & NY & 9024 & 2 & 1 & 1 & 50.83 & 2 & 40836 & 51376 \\ \hline U0358841 & IL & 801 & 1 & 1 & 0 & 56.8 & 150 & 81324 & 42115 \\ \hline U0401403 & MO & 285.37 & 2 & 1 & 0 & 58.25 & 45 & 27377 & 11630 \\ \hline U0387215 & NJ & 44.8 & 0 & 0 & 0 & 56 & 0 & 74284 & 13948 \\ \hline U0270598 & FL & 102 & 0 & 0 & 1 & 66.83 & 20 & 42255 & 34230 \\ \hline U0361858 & VA & 5763.03 & 0 & 0 & 1 & 60.66 & 50 & 71113 & 24921 \\ \hline U0380062 & CA & 2912.6 & 5 & 1 & 1 & 71.85 & 2500 & 33511 & 27115 \\ \hline U0372688 & TX & 302 & 0 & 0 & 1 & 65.21 & 15 & 9783 & 14012 \\ \hline U0396743 & CA & 1048.53 & 0 & 0 & 1 & 71.85 & 0 & 22429 & 49418 \\ \hline \end{tabular}

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

The Organisational Leadership Audit

Authors: William Tate

1st Edition

0955970717, 978-0955970719

More Books

Students also viewed these Accounting questions

Question

2. What is the business value of security and control?

Answered: 1 week ago