Data

  Models succor us define and condense relations betwixt variables. Understanding how mode variables recount to each other succors officees prophesy and amend exploit. For illustration, a marketing supervisor capability be animated in standarding the relation betwixt plan expenditures and sales revenues. Consider the postulatesset adown and meet to the questions that flourish: Advertisement ($'000)   Sales ($'000) 1068    4489 1026    5611 767      3290 885      4113 1156    4883 1146    5425 892      4414 938      5506 769      3346 677      3673 1184    6542 1009    5088 Construct a plant frame delay this postulates. Do you note a relation betwixt twain variables? Use Excel to fit a straight retirement continuity to the postulates. What is the prompt retirement standard? (Hint: You can flourish the steps outlined on page 497 of the textbook.) What is the float? What does the float divulge us?Is the float symbolical? What is the stop? Is it meaningful? What is the appreciate of the retirement coefficient,r? What is the appreciate of the coefficient of purpose, r^2? What does r^2 divulge us? Use the standard to prophesy sales and the office spends $950,000 in plan. Does the standard underrate or overestimates ales?