Assignment 1 Activities ting emails sent ting phone calls made kedIn connections tments from the Finding Activities ointments made from email ointments made from phone calls Assignment 2 Assignment 3 January February March April May June July August September October 100 105 107 104 110 115 110 116 120 121 84 86 87 84 75 75 71 67 67 60 55 56 55 56 54 50 48 50 47 45 ointments made from new LinkedIn connections Activity Effectiveness ointments per email ointments per phone call ointments per new Linkedin connection activities did the salesperson increase and decrease over time?Based on activities, make a line graph and explain your insights.. pleting the Finding Activity effectiveness table h the ratios over time. Salesperson effectivess for each activity and did he improve or worsen year? Based on finding acitivity effectiveness, make a line graph and explain your 10 11 8 7 5 5 385 386 565 15 754 565 17 18 19 21 4 5 3 5 5 4 Assignment#2: Analyzing Data The attached spreadsheet displays selling metrics for a salesperson working at Adobe B2B services. After downloading the spreadsheet, analyze the numbers and answer the following questions: I. The section "Finding Activities" gives a raw count of the number of prospecting activities the salesperson attempted each month. Graph out three different activities over the year. What activities did the salesperson increase over time and what activities did the salesperson decrease? 2. The section "Appointment from the Finding Activities" gives the raw count of appointments that were made from the three different finding activities. Use these numbers to fill out the "Finding Activity Effectiveness" section, which give the ratios for the number of appointments made per finding activity each month. The first column offers an example of the calculations. 3. Graph the ratios over time. Describe the salesperson effectiveness for each activity overtime. Did the salesperson improve or worsen throughout the year?