Question: The data on the worksheet titled Problem 2 contains information regarding age, financing amount, and credit score for twenty-five (25) customers of a jewelry store.

 The data on the worksheet titled "Problem 2 contains information regarding

The data on the worksheet titled "Problem 2 contains information regarding age, financing amount, and credit score for twenty-five (25) customers of a jewelry store. The instructions for this question ask you to create a comparative visualization for two of the variables and asks you about what the visualization shows. Problem 2.1 Create a scatter chart of Customer Age vs Purchase Amount and place the visualization to the right of the data, below the Problem answer blanks. Problem 2.2 Add a trendline to the scatter chart you created in Problem 2.1. Problem 2.3 What kind of relationship do you see between Customer Age and Financing Amount? Positive, negative or none. 354 Problem 2.4 What does this kind of relationship suggest about the variables Customer Age and Financing Amount? When the variable Customer Age goes up, the variable Financing Amount _. Goes up, goes down or no change Customer Number Customer Age Financing Amount ($) Credit Score 1 32 350 746 2 45 189 760 3 38 716 744 4 50 431 749 5 48 490 696 6 34 527 673 7 36 847 625 8 31 747 9 42 528 743 10 28 950 638 11 48 360 622 12 38 646 837 13 41 468 884 14 41 549 690 15 58 281 718 16 34 495 645 17 39 603 529 18 37 420 590 19 62 455 837 20 43 551 831 21 54 393 600 22 28 742 683 23 35 330 723 24 28 888 692 25 28 981 775

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!