Question: ** solve it using excel ** The table below represents the sales quantities for 50 different products for 12 months in 2021. Product Name January

** solve it using excel ** The table below

** solve it using excel **

The table below represents the sales quantities for 50 different products for 12 months in 2021. Product Name January October November December Product 1 Product 2 Product 3 1,146 3,337 2,755 1,524 3,583 1,873 Product 4 3,284 Product 5 Product 6 2,591 2,559 4,489 Product 7 Product 8 Product 9 Product 10 Product 11 4,019 3,211 1,738 1,899 3,034 2,922 4,707 1,791 1,547 1,856 1,665 4,954 3,894 4,452 3,469 4,156 4,252 2,377 February 1,967 1,447 4,523 3,286 3,536 2,724 4,010 3,887 4,727 4,197 2,668 2,036 4,903 2,021 1,786 4,369 1,050 3,005 September 1,268 3,329 2,885 4,237 3,353 1,011 4,164 2,954 1,431 1,194 3,325 3,318 1,484 1,012 3,786 4,855 4,890 1,524 4,192 2,600 3,469 2,953 4,224 2,360 4,417 3,984 2,501 4,267 3,869 4,793 1,657 1,528 3,275 Product 12 Product 13 3,127 1,741 2,931 Product 14 Product 15 Product 16 Product 17 Product 18 4,508 1,833 Product 19 3,327 2,658 2,158 1,232 4,180 3,971 2,014 3,358 3,593 3,900 3,496 4,098 1,828 2,931 2,774 4,148 4,652 3,164 3,411 3,332 4,989 3,982 3,436 4,867 3,246 3,076 3,576 4,789 4,385 4,953 1,362 4,310 3,293 4,428 2,108 3,109 4,587 2,546 2,092 1,143 1,219 Product 20 Product 21 Product 22 Product 23 1,825 4,420 2,959 3,498 3,710 Month March April May June July August 4,347 4,016 2,976 2,178 1,962 4,960 4,776 2,287 4,293 4,868 1,276 1,274 1,581 4,375 3,098 2,326 1,267 3,438 4,441 2,041 4,641 2,292 3,789 3,949 4,244 1,983 2,138 1,074 2,637 3,627 4,890 1,235 3,079 4,692 4,104 3,910 4,411 1,563 1,220 3,980 2,718 1,022 4,743 4,787 3,700 3,097 2,235 1,931 3,289 2,990 1,862 2,497 4,894 2,819 2,637 2,637 3,791 4,647 3,670 2,436 1,819 2,250 1,796 1,685 3,665 4,775 3,451 4,990 1,702 1,918 2,199 3,504 3,480 3,256 3,494 1,521 1,469 2,377 2,932 4,909 1,621 2,183 4,933 4,280 4,492 2,062 1,548 4,332 1,174 4,462 3,974 1,932 2,120 4,087 2,623 2,421 2,127 2,502 1,010 1,218 4,991 3,373 3,705 1,837 2,144 2,837 3,083 4,920 2,672 4,936 3,947 1,549 2,507 1,644 3,680 2,207 4,196 4,223 3,474 3,433 1,473 3,101 1,243 1,428 4,870 4,919 1,465 3,802 3,479 4,206 3,828 4,307 3,472 4,107 1,442 1,220 4,609 3,479 3,337 1,876 2,516 1,736 1,558 1,090 1,077 3,870 4,415 4,198 2,251 4,180 2,756 4,265 3,578 4,134 1,555 4,657 1,521 2,821 2,008 1,256 1,906 2,512 2,746 1,437 2,628 3,674 3,221 4,177 2,780 1,374 4,737 1,080 3,207 3,159 4,175 2,252 1,445 1,548 4,784 2,346 3,155 1,508 3,269 3,661 4,835 4,206 4,130 3,976 2,266 4,494 2,323 1,748 4,735 4,072 1,001 4,118 3,586 2,204 4,708 4,531 3,567 2,045 3,408 4,008 3,484 2,409 1,270 3,578 4,568 4,694 2,371 1,301 2,208 3,495 1,487 3,056 2,353 3,933 3,589 2,584 4,017 3,809 2,778 2,158 3,461 3,794 4,782 1,118 4,850 2,992 1,808 1,447 1,082 3,215 1,215 2,928 3,916 4,643 1,977 3,898 3,037 2,726 2,784 2,634 1,684 3,797 3,882 1,227 3,148 2,565 1,949 4,924 2,576 2,148 2,078 1,037 4,253 2,499 3,345 3,998 4,267 1,650 2,802 3,607 4,804 1,360 1,383 2,564 3,582 4,833 4,523 2,679 2,376 1,061 1,451 1,853 3,831 1,891 4,116 3,645 3,463 3,533 3,932 2,304 4,337 4,938 2,892 2,836 2,433 3,629 1,481 3,844 2,433 1,817 2,597 4,695 1,971 3,417 1,068 3,697 3,932 4,813 4,413 2,006 3,521 4,478 4,116 4,892 1,079 2,083 3,826 3,795 4,355 2,583 2,698 3,910 1,948 4,525 3,097 Product 24 2,548 1,509 4,413 4,791 4,170 2,240 3,927 1,404 3,025 3,612 3,074 2,075 3,342 4,626 2,621 1,673 3,685 1,992 1,541 4,041 3,716 Product 25 Product 26 4,195 1,843 2,031 Product 27 2,142 Product 28 1,916 Product 29 1,263 4,952 3,376 2,274 4,439 4,219 3,009 Product 30 Product 31 1,077 1,604 Product 32 Product 33 Product 34 Product 35 2,756 3,726 2,588 3,589 4,017 3,629 4,733 4,592 2,132 4,661 3,563 3,222 3,941 3,016 1,437 4,782 3,621 3,517 4,573 4,450 2,885 1,441 3,603 1,291 3,020 4,344 1,794 3,355 4,118 3,056 3,259 4,543 4,040 2,338 4,500 2,859 1,198 Product 36 Product 37 Product 38 Product 39 2,550 4,703 1,648 4,837 1,111 4,500 4,033 1,162 4,685 1,777 4,330 4,458 2,070 2,720 2,368 1,679 3,278 2,891 3,080 Product 40 Product 41 Product 42 3,038 4,773 1,094 2,127 1,883 3,321 2,725 4,109 3,207 3,321 2,982 2,864 3,824 4,143 1,403 3,988 1,536 3,274 1,670 2,778 4,091 3,536 2,975 2,834 4,132 2,994 3,283 4,348 4,269 3,038 4,495 4,057 1,040 4,377 2,243 3,620 3,760 2,261 2,886 4,136 1,994 1,792 2,233 3,139 1,488 3,482 2,152 3,113 2,240 3,111 Product 43 Product 44 Product 45 Product 46 4,855 4,433 2,055 Product 47 Product 48 Product 49 Product 50 4,447 4,611 1,353 4,108 2,008 4,442 4,128 Now, calculate the following: 1- The average sales for each product in 12 months. 2- The maximum sales for each product in 12 months. 3- The minimum sales for each product in 12 months

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 General Management Questions!