SWDExercisesR1Data

xlsx

School

University of Illinois, Chicago *

*We aren’t endorsed by this school

Course

602

Subject

Statistics

Date

Jun 18, 2024

Type

xlsx

Pages

21

Uploaded by AdmiralSeaLion3607

Report
EXERCISE 2.9 & 2.10 Average time to close deals (days) Product Direct Sales Indirect Sales Total Sales A 83 145 128 B 54 131 127 C 89 122 107 D 90 129 118 A 0 50 100 150 200 250 300 350 400
B C D Average Time to Close (days) Direct Sales Indirect Sales Total Sales Product
EXERCISE 3.9 DATA TO GRAPH FIG 3.9 Month 2018 2019 TITLE January 38000 101000 February 47000 78000 March 49000 91000 April 42000 77000 May 42000 78000 June 38000 71000 July 43000 78000 August 52000 62000 September 49000 68000 October 67000 50000 November 74000 43000 December 86000 41000 0 20,000 40,000 60,000 80,000 100,000 120,000 Monthly V Number o
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Vehicles Sold Trend of Cars, January-December 2018 2019
EXERCISE 3.8 FIG 3.8 TITLE May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Jul A 0 10 20 30 40 50 60 70 80 90 100 Customer Satisfaction Score
NOTES + DATA TO GRAPH Year Month Original x-axis 2018 May May 18 2018 Jun Jun 18 2018 Jul Jul 18 2018 Aug Aug 18 2018 Sep Sep 18 2018 Oct Oct 18 2018 Nov Nov 18 2018 Dec Dec 18 2019 Jan Jan 19 2019 Feb Feb 19 2019 Mar Mar 19 2019 Apr Apr 19 2019 May May 19 2019 Jun Jun 19 2019 Jul Jul 19 2019 Aug Aug 19 2019 Sep Sep 19 2019 Oct Oct 19 2019 Nov Nov 19 2019 Dec Dec 19 Aug Sep Oct Nov Dec
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Customer Satisfaction Score 42 37 25 21 33 35 45 42 28 37 41 44 48 65 62 85 89 77 76 85
EXERCISE 3.10 DATA TO GRAPH Type 2016 2017 2018 2019 Credit Card 92.1 89.4 94.0 97.1 Home Equity Line of Cre 5.6 12.7 47.5 65.0 Fixed-Term Loan 48.2 53.8 61.9 53.7 Total 58.9 47.6 78.4 75.6 FIG 3.10 2016 2017 2018 0 10 20 30 40 50 60 70 80 90 100 Percent Automation Trend in Payments (% Auto-P Credit Card Home Equity Line of Credit Fixed-Term Loan Total Percent (%)
2019 Pay)
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
EXERCISE 4.7 DATA TO GRAPH Year Quarter COMPETITOR ACOMPETITOR BCOMPETITOR CCOMPETITOR D 2016 Q3 0.0% 3.1% 3.5% 0.0% Q4 0.0% 3.2% 3.5% 0.0% 2017 Q1 0.0% 3.3% 3.7% 0.0% Q2 0.0% 3.3% 3.7% 0.0% Q3 0.0% 3.3% 3.6% 0.0% Q4 0.3% 3.3% 3.4% 0.0% 2018 Q1 0.9% 3.3% 3.3% 0.0% Q2 1.9% 3.2% 3.2% 0.0% Q3 3.0% 3.1% 3.1% 0.0% Q4 3.7% 3.1% 3.0% 0.4% 2019 Q1 5.1% 3.1% 2.9% 0.9% Q2 6.1% 3.1% 2.7% 1.3% Q3 6.1% 3.1% 2.7% 1.5% Q4 6.5% 3.0% 2.6% 2.0% FIG 4.3 Market share over time 1% 2% 3% 4% 5% 6% 7% MARKET SHARE
Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 2016 2017 2018 2019 0%
For Tableau COMPETITOR E OUR PRODUCT Year Quar COMPETITOR ACOMPETITOR BCOMPETITOR C 0.0% 0.5% 2016 Q3 0.0% 3.1% 3.5% 0.0% 1.4% 2016 Q4 0.0% 3.2% 3.5% 0.0% 1.8% 2017 Q1 0.0% 3.3% 3.7% 0.0% 2.1% 2017 Q2 0.0% 3.3% 3.7% 0.4% 2.1% 2017 Q3 0.0% 3.3% 3.6% 0.7% 2.5% 2017 Q4 0.3% 3.3% 3.4% 0.8% 2.7% 2018 Q1 0.9% 3.3% 3.3% 0.9% 3.0% 2018 Q2 1.9% 3.2% 3.2% 1.0% 3.2% 2018 Q3 3.0% 3.1% 3.1% 1.0% 3.3% 2018 Q4 3.7% 3.1% 3.0% 1.1% 3.4% 2019 Q1 5.1% 3.1% 2.9% 1.1% 3.5% 2019 Q2 6.1% 3.1% 2.7% 1.3% 3.5% 2019 Q3 6.1% 3.1% 2.7% 1.3% 3.6% 2019 Q4 6.5% 3.0% 2.6% COMPETITOR A OUR PRODUCT COMPETITOR B COMPETITOR C COMPETITOR D COMPETITOR E 2.0% 3.0% 4.0% 5.0% 6.0% 7.0% Cha
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
3 Q4 Q3 Q4 Q1 Q2 Q3 Q4 Q1 2016 2017 0.0% 1.0% COMPETITOR A COMPETITOR B COMPETITOR
COMPETITOR DCOMPETITOR EOUR PRODUCT 0.0% 0.0% 0.5% 0.0% 0.0% 1.4% 0.0% 0.0% 1.8% 0.0% 0.0% 2.1% 0.0% 0.4% 2.1% 0.0% 0.7% 2.5% 0.0% 0.8% 2.7% 0.0% 0.9% 3.0% 0.0% 1.0% 3.2% 0.4% 1.0% 3.3% 0.9% 1.1% 3.4% 1.3% 1.1% 3.5% 1.5% 1.3% 3.5% 2.0% 1.3% 3.6% art Title
1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 2018 2019 C COMPETITOR D COMPETITOR E OUR PRODUCT
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
EXERCISE 4.8 DATA TO GRAPH Successful Opportunities by Center (FLU) Center Vaccines Opportunities Success % Average BDT 2,519 25,703 9.8% 12.1% DBA 4,142 31,249 13.3% 12.1% FMP 4,075 30,548 13.3% 12.1% LTA 1,840 18,857 9.8% 12.1% MVT 1,478 16,474 9.0% 12.1% OCE 4,495 22,497 20.0% 12.1% ODP 2,244 15,063 14.9% 12.1% ONK 1,546 17,064 9.1% 12.1% PLB 2,589 21,933 11.8% 12.1% RDM 1,796 17,479 10.3% 12.1% SBC 2,036 21,937 9.3% 12.1% SDT 2,221 13,983 15.9% 12.1% SEP 3,630 21,395 17.0% 12.1% WBA 1,091 13,042 8.4% 12.1% WLT 1,954 24,562 8.0% 12.1% TOTAL 37,656 311,786 12.1% 12.1% 15% 20% 25%
BDT DBA FMP LTA MVT OC 0% 5% 10%
FIGURE 4.8 Successful Opportunities by Cent BDT DBA FMP LTA MVT OCE ODP ONK PLB RDM 0% 2% 4% 6% 8% 10% 12% 14% 16% 18% 20% MEDICAL CENTER SUCCESS RATE AVERAGE 12.1%
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
CE ODP ONK PLB RDM SBC SDT SEP WBA WLT Success % Average
ter (FLU) M SBC SDT SEP WBA WLT
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help