Question
Use the information on the Data worksheet and pivot tables, formulas, and/or functions to answer the following questions. Q1a. What was the lowest percent change
Use the information on the Data worksheet and pivot tables, formulas, and/or functions to answer the following questions.
Q1a. What was the lowest percent change (either increase or decrease) from 2022 to 2023 among the four regions? (Enter the answer as a positive number.) fill in the blank 1 of 1%
Q2a. What was the highest percentage of revenue in a region to total revenue in 2023 among the four regions?
Q3a. What was the higher percent change (either increase or decrease) from 2022 to 2023 between the two services? (Enter the answer as a positive number.) fill in the blank 1 of 1%
What was the percentage of that amount out of total revenue in 2023 from both services? fill in the blank 1 of 1%
table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";} tr {mso-height-source:auto;} col {mso-width-source:auto;} td {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:black; font-size:12.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Calibri; mso-generic-font-family:auto; mso-font-charset:134; text-align:general; vertical-align:bottom; border:none; white-space:nowrap; mso-rotate:0;} .xl37 {font-size:11.0pt; font-family:Calibri, sans-serif; mso-font-charset:0;} .xl39 {font-size:11.0pt; font-weight:700; font-family:Calibri, sans-serif; mso-font-charset:0; text-align:center;} .xl41 {font-size:11.0pt; font-family:Calibri, sans-serif; mso-font-charset:0; text-align:center;}
Year | Region | Customer | Service | Amount | |
2022 | South | Robert | Repair | 1,250 | |
2022 | South | Ashton | Repair | 1,270 | |
2023 | West | Pastor | Installation | 4,490 | |
2023 | West | Pastor | Installation | 6,340 | |
2022 | West | Beldon | Repair | 2,100 | |
2022 | North | Khalid | Installation | 6,450 | |
2022 | South | Robert | Repair | 1,190 | |
2022 | North | Khalid | Repair | 1,000 | |
2023 | West | Pastor | Repair | 2,260 | |
2023 | North | Sawyer | Repair | 640 | |
2022 | East | Master | Repair | 1,750 | |
2022 | West | Pastor | Installation | 4,020 | |
2022 | East | Cleary | Repair | 1,520 | |
2023 | West | Beldon | Repair | 650 | |
2022 | South | Robert | Repair | 1,610 | |
2023 | West | Pastor | Installation | 3,870 | |
2023 | South | Ashton | Installation | 5,720 | |
2022 | West | Beldon | Installation | 7,070 | |
2023 | South | Ashton | Repair | 2,260 | |
2022 | East | Cleary | Repair | 2,160 | |
2023 | South | Robert | Installation | 5,940 | |
2023 | South | Robert | Repair | 720 | |
2022 | North | Sawyer | Installation | 6,720 | |
2023 | North | Khalid | Repair | 980 | |
2023 | East | Cleary | Installation | 3,790 | |
2023 | North | Sawyer | Repair | 2,420 | |
2023 | South | Robert | Installation | 4,370 | |
2023 | North | Khalid | Installation | 5,660 | |
2022 | South | Ashton | Installation | 5,230 | |
2023 | North | Sawyer | Repair | 1,350 | |
2023 | South | Ashton | Installation | 3,830 | |
2022 | East | Master | Repair | 1,200 | |
2022 | North | Sawyer | Repair | 2,100 | |
2022 | North | Khalid | Installation | 6,320 | |
2022 | East | Master | Installation | 4,430 | |
2022 | North | Khalid | Repair | 1,530 | |
2022 | North | Khalid | Repair | 1,070 | |
2022 | East | Master | Installation | 5,680 | |
2022 | North | Khalid | Repair | 1,070 | |
2023 | South | Robert | Installation | 4,730 | |
2022 | South | Ashton | Installation | 3,570 | |
2023 | East | Cleary | Repair | 1,760 | |
2022 | South | Ashton | Repair | 820 | |
2023 | North | Khalid | Installation | 4,680 | |
2023 | West | Pastor | Repair | 2,330 | |
2022 | North | Sawyer | Installation | 3,550 | |
2023 | South | Robert | Repair | 810 | |
2022 | West | Beldon | Repair | 1,640 | |
2022 | North | Khalid | Installation | 3,860 | |
2023 | West | Pastor | Repair | 2,210 | |
2023 | West | Beldon | Repair | 1,480 | |
2022 | South | Ashton | Installation | 4,880 | |
2023 | North | Khalid | Repair | 2,010 | |
2022 | East | Cleary | Installation | 7,150 | |
2023 | South | Ashton | Installation | 4,310 | |
2023 | North | Khalid | Repair | 1,250 | |
2022 | North | Khalid | Installation | 3,520 | |
2023 | North | Sawyer | Installation | 7,240 | |
2022 | North | Sawyer | Repair | 1,450 | |
2022 | East | Master | Installation | 6,910 | |
2022 | East | Master | Installation | 6,770 | |
2022 | South | Ashton | Installation | 6,530 | |
2022 | North | Khalid | Installation | 5,110 | |
2023 | West | Pastor | Repair | 1,930 | |
2023 | North | Khalid | Installation | 3,990 | |
2023 | South | Ashton | Installation | 5,340 | |
2022 | East | Cleary | Installation | 3,790 | |
2022 | South | Robert | Installation | 7,020 | |
2022 | South | Ashton | Repair | 2,250 | |
2023 | South | Robert | Repair | 2,390 | |
2023 | East | Cleary | Repair | 1,180 | |
2023 | North | Sawyer | Repair | 2,210 | |
2023 | South | Robert | Repair | 1,700 | |
2022 | North | Sawyer | Installation | 6,180 | |
2022 | North | Sawyer | Repair | 1,980 | |
2022 | West | Beldon | Installation | 7,310 | |
2022 | West | Beldon | Repair | 1,990 | |
2023 | North | Sawyer | Installation | 5,450 | |
2023 | North | Sawyer | Installation | 6,670 | |
2023 | North | Sawyer | Installation | 4,280 | |
2023 | West | Beldon | Installation | 4,660 | |
2023 | North | Khalid | Repair | 2,090 | |
2023 | North | Sawyer | Installation | 6,300 | |
2023 | East | Cleary | Installation | 5,990 | |
2022 | South | Robert | Installation | 5,190 | |
2023 | South | Robert | Installation | 5,090 | |
2022 | South | Ashton | Installation | 7,180 | |
2023 | East | Cleary | Installation | 7,180 | |
2022 | East | Cleary | Repair | 1,160 | |
2022 | South | Robert | Installation | 7,400 | |
2023 | West | Beldon | Repair | 2,410 | |
2022 | East | Master | Installation | 6,320 | |
2022 | South | Robert | Repair | 2,050 | |
2022 | West | Beldon | Installation | 4,450 | |
2022 | East | Cleary | Repair | 990 | |
2023 | West | Pastor | Installation | 4,650 | |
2023 | North | Khalid | Repair | 1,490 | |
2023 | West | Pastor | Installation | 7,070 | |
2023 | East | Master | Repair | 630 | |
2022 | North | Sawyer | Installation | 7,120 | |
2023 | North | Sawyer | Repair | 2,480 | |
2022 | North | Khalid | Installation | 4,320 | |
2023 | North | Khalid | Repair | 1,760 | |
2022 | North | Khalid | Installation | 4,580 | |
2023 | West | Pastor | Repair | 2,090 | |
2022 | South | Robert | Repair | 1,340 | |
2022 | South | Robert | Installation | 4,010 | |
2023 | South | Ashton | Installation | 6,660 | |
2023 | East | Master | Repair | 1,300 | |
2023 | East | Master | Repair | 2,100 | |
2023 | West | Pastor | Repair | 1,690 | |
2022 | East | Master | Repair | 2,260 | |
2023 | East | Master | Installation | 6,230 | |
2022 | West | Pastor | Installation | 6,100 | |
2023 | West | Beldon | Repair | 1,310 | |
2022 | South | Ashton | Installation | 6,250 | |
2023 | West | Pastor | Installation | 7,220 | |
2022 | North | Sawyer | Installation | 3,660 | |
2022 | West | Pastor | Installation | 4,530 | |
2022 | West | Pastor | Installation | 7,330 | |
2023 | South | Ashton | Repair | 1,970 | |
2022 | North | Sawyer | Installation | 7,330 | |
2023 | North | Sawyer | Repair | 2,410 | |
2023 | South | Robert | Installation | 7,260 | |
2022 | South | Robert | Installation | 4,110 | |
2022 | North | Khalid | Installation | 5,420 | |
2022 | East | Cleary | Installation | 3,580 | |
2022 | East | Master | Installation | 7,270 | |
2022 | West | Beldon | Installation | 5,760 | |
2022 | North | Khalid | Installation | 6,210 | |
2022 | East | Cleary | Repair | 880 | |
2022 | North | Sawyer | Repair | 1,600 | |
2023 | West | Pastor | Installation | 7,020 | |
2023 | West | Pastor | Repair | 2,390 | |
2022 | North | Khalid | Repair | 1,400 | |
2022 | East | Cleary | Repair | 2,190 | |
2022 | North | Sawyer | Installation | 7,090 | |
2023 | South | Robert | Installation | 4,630 | |
2023 | South | Robert | Installation | 3,870 | |
2022 | South | Ashton | Installation | 5,400 | |
2022 | North | Khalid | Installation | 6,550 | |
2023 | West | Beldon | Repair | 820 | |
2023 | East | Master | Installation | 4,380 | |
2023 | West | Beldon | Installation | 5,040 | |
2022 | East | Cleary | Installation | 7,480 | |
2023 | South | Ashton | Repair | 1,070 | |
2023 | East | Master | Installation | 7,390 | |
2023 | East | Cleary | Repair | 2,240 | |
2022 | South | Robert | Repair | 1,220 | |
2023 | West | Beldon | Repair | 1,260 | |
2022 | North | Sawyer | Installation | 4,750 | |
2023 | East | Master | Repair | 840 | |
2022 | South | Ashton | Repair | 630 | |
2023 | West | Beldon | Repair | 1,220 | |
2022 | South | Ashton | Repair | 620 | |
2023 | West | Pastor | Installation | 5,910 | |
2023 | South | Robert | Repair | 1,270 | |
2022 | East | Cleary | Installation | 4,990 | |
2023 | South | Ashton | Installation | 4,000 | |
2023 | East | Master | Installation | 4,590 | |
2023 | North | Sawyer | Installation | 6,860 | |
2022 | East | Master | Installation | 4,960 | |
2023 | West | Pastor | Installation | 7,180 | |
2023 | North | Khalid | Repair | 1,900 | |
2022 | West | Pastor | Repair | 860 | |
2022 | East | Master | Installation | 6,060 | |
2023 | South | Robert | Installation | 4,980 | |
2023 | North | Khalid | Installation | 4,640 | |
2023 | North | Sawyer | Repair | 1,690 | |
2022 | West | Pastor | Repair | 2,040 | |
2023 | West | Beldon | Installation | 5,160 | |
2023 | East | Master | Repair | 600 | |
2023 | South | Ashton | Installation | 5,700 | |
2023 | East | Master | Installation | 5,150 | |
2022 | East | Master | Repair | 800 | |
2023 | West | Beldon | Repair | 2,030 | |
2023 | North | Sawyer | Repair | 730 | |
2022 | West | Beldon | Installation | 5,920 | |
2022 | East | Master | Installation | 4,250 | |
2022 | North | Sawyer | Installation | 7,250 | |
2022 | North | Sawyer | Repair | 1,580 | |
2022 | West | Beldon | Repair | 790 | |
2022 | South | Robert | Repair | 860 | |
2023 | West | Beldon | Repair | 2,380 | |
2022 | West | Pastor | Repair | 2,040 | |
2023 | North | Sawyer | Repair | 1,490 | |
2023 | South | Ashton | Repair | 2,400 | |
2023 | East | Master | Installation | 4,030 | |
2022 | North | Khalid | Installation | 5,210 | |
2022 | North | Khalid | Repair | 800 | |
2023 | West | Beldon | Repair | 2,490 | |
2023 | East | Cleary | Repair | 1,490 | |
2022 | East | Master | Repair | 1,780 | |
2022 | North | Khalid | Installation | 4,020 | |
2023 | West | Pastor | Installation | 3,720 | |
2023 | East | Cleary | Installation | 6,590 | |
2023 | South | Robert | Installation | 6,590 | |
2022 | North | Sawyer | Repair | 1,540 | |
2023 | North | Sawyer | Installation | 7,420 | |
2023 | South | Ashton | Installation | 7,090 | |
2022 | South | Robert | Repair | 1,640 | |
2023 | North | Khalid | Repair | 730 | |
2022 | South | Ashton | Repair | 2,300 | |
2023 | East | Cleary | Repair | 990 | |
2022 | South | Robert | Repair | 2,240 | |
2023 | West | Beldon | Installation | 6,800 | |
2022 | West | Beldon | Repair | 650 | |
2023 | East | Master | Installation | 6,090 | |
2023 | South | Robert | Installation | 3,760 | |
2022 | West | Pastor | Repair | 1,500 | |
2022 | North | Khalid | Repair | 1,560 | |
2022 | West | Pastor | Installation | 5,780 | |
2022 | South | Ashton | Installation | 6,510 | |
2022 | East | Cleary | Installation | 5,840 | |
2022 | South | Robert | Installation | 6,470 | |
2022 | West | Beldon | Repair | 610 | |
2023 | South | Robert | Installation | 6,620 | |
2022 | West | Beldon | Installation | 5,450 | |
2023 | East | Master | Installation | 7,390 | |
2023 | East | Master | Repair | 2,030 | |
2023 | North | Sawyer | Repair | 1,350 | |
2022 | West | Pastor | Repair | 2,320 | |
2023 | North | Khalid | Repair | 1,370 | |
2023 | East | Master | Repair | 2,500 | |
2022 | South | Ashton | Repair | 620 | |
2022 | South | Robert | Repair | 760 | |
2023 | North | Sawyer | Installation | 4,240 | |
2022 | East | Master | Installation | 3,900 | |
2023 | West | Beldon | Installation | 4,620 | |
2022 | West | Pastor | Installation | 5,720 | |
2023 | West | Beldon | Installation | 6,810 | |
2022 | North | Sawyer | Repair | 1,120 | |
2023 | North | Khalid | Installation | 6,650 | |
2023 | West | Pastor | Installation | 5,350 | |
2023 | South | Robert | Repair | 1,630 | |
2023 | East | Cleary | Repair | 1,310 | |
2022 | North | Khalid | Repair | 1,450 | |
2022 | North | Khalid | Installation | 4,300 | |
2022 | East | Master | Installation | 7,220 | |
2022 | South | Robert | Repair | 1,530 | |
2022 | North | Sawyer | Repair | 1,170 | |
2022 | North | Sawyer | Repair | 1,260 | |
2023 | South | Robert | Installation | 5,460 | |
2022 | North | Khalid | Repair | 1,600 | |
2022 | South | Ashton | Repair | 1,240 | |
2022 | East | Cleary | Installation | 7,100 | |
2023 | East | Master | Repair | 2,430 | |
2023 | South | Ashton | Installation | 3,850 | |
2022 | South | Robert | Installation | 4,920 | |
2023 | North | Khalid | Installation | 4,190 | |
2023 | North | Khalid | Repair | 1,240 | |
2022 | East | Master | Installation | 6,480 | |
2022 | West | Pastor | Repair | 760 | |
2023 | West | Beldon | Installation | 7,200 | |
2022 | North | Khalid | Repair | 610 | |
2022 | East | Master | Repair | 2,050 | |
2022 | South | Ashton | Repair | 1,920 | |
2023 | North | Khalid | Installation | 7,480 | |
2023 | North | Khalid | Repair | 1,510 | |
2022 | East | Cleary | Repair | 2,450 | |
2022 | West | Beldon | Repair | 830 | |
2023 | East | Cleary | Repair | 2,400 | |
2023 | East | Master | Installation | 6,280 | |
2023 | East | Cleary | Installation | 6,020 | |
2023 | North | Khalid | Repair | 990 | |
2022 | North | Khalid | Repair | 750 | |
2022 | East | Master | Installation | 5,280 | |
2022 | West | Beldon | Repair | 2,480 | |
2022 | East | Cleary | Installation | 6,950 | |
2022 | North | Sawyer | Repair | 2,180 | |
2023 | East | Master | Installation | 5,200 | |
2022 | East | Master | Repair | 1,000 | |
2023 | East | Cleary | Installation | 4,690 | |
2023 | South | Ashton | Repair | 1,840 | |
2023 | North | Sawyer | Installation | 3,500 | |
2022 | East | Master | Installation | 5,300 | |
2023 | West | Beldon | Installation | 5,540 | |
2022 | South | Robert | Repair | 1,770 | |
2023 | West | Pastor | Repair | 2,240 | |
2022 | West | Pastor | Repair | 910 | |
2023 | East | Master | Repair | 2,140 | |
2022 | West | Beldon | Installation | 3,590 | |
2023 | West | Pastor | Installation | 5,230 | |
2023 | West | Pastor | Installation | 3,980 | |
2023 | North | Sawyer | Installation | 6,390 | |
2022 | West | Pastor | Repair | 1,250 | |
2023 | West | Beldon | Installation | 4,520 | |
2023 | North | Khalid | Installation | 3,780 | |
2022 | North | Sawyer | Installation | 4,350 | |
2023 | West | Beldon | Installation | 5,310 | |
2022 | South | Robert | Repair | 1,160 | |
2023 | South | Ashton | Repair | 1,060 | |
2022 | West | Pastor | Repair | 1,320 | |
2022 | East | Cleary | Repair | 1,520 | |
2022 | East | Cleary | Repair | 2,140 | |
2023 | East | Cleary | Repair | 1,620 | |
2022 | South | Ashton | Repair | 760 | |
2023 | South | Ashton | Repair | 1,840 | |
2023 | East | Cleary | Repair | 980 | |
2023 | North | Khalid | Installation | 5,410 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started