Answered step by step
Verified Expert Solution
Question
1 Approved Answer
1. Create sumif/countif tables using the data below: Order # 8005-2218 Revenue Salesperson Location $97,104 Harry Fresno 8005-2219 8005-2220 8005-2221 $235,055 Vishal Madera $109,141
1. Create sumif/countif tables using the data below: Order # 8005-2218 Revenue Salesperson Location $97,104 Harry Fresno 8005-2219 8005-2220 8005-2221 $235,055 Vishal Madera $109,141 Vishal Clovis $195,185 Anna Tulare 8005-2222 $81,371 Jenny Fresno 8005-2223 $96,363 Harry Clovis 8005-2224 $66,618 Vishal Fresno 8005-2225 $63,484 Miguel Fresno 8005-2226 $130,032 Anna Madera 8005-2227 $261,194 Harry Tulare 8005-2228 $39,509 Vishal Madera 8005-2229 $49,453 Jenny Fresno 8005-2230 $75,967 Harry Fresno 8005-2231 $125,177 Vishal Clovis 8005-2232 $33,277 Harry Fresno 8005-2233 $147,042 Miguel Fresno 8005-2234 $115,876 Anna Madera 8005-2235 $62,453 Harry Hanford 8005-2236 $118,316 Anna Tulare 8005-2237 $191,572 Miguel Madera 8005-2238 $69,378 Anna Clovis 8005-2239 $90,623 Harry Fresno 8005-2240 $40,555 Harry Clovis 8005-2241 $82,848 Anna Fresno 8005-2242 $175,864 Miguel Fresno 8005-2243 $37,920 Anna Hanford 8005-2244 $40,539 Miguel Madera 8005-2245 $76,230 Miguel Clovis 8005-2246 $78,196 Harry Fresno 8005-2247 $61,016 Jenny Madera 8005-2248 $130,970 Miguel Hanford 8005-2249 $154,177 Harry Madera 8005-2250 $69,382 Miguel Hanford 8005-2251 $244,634 Anna Tulare 8005-2252 $38,757 Jenny Madera 8005-2253 $174,625 Vishal Clovis 8005-2254 $102,218 Jenny Fresno 8005-2255 $61,616 Vishal Fresno 8005-2256 $259,624 Vishal Clovis 8005-2257 $65,486 Annal Hanford Table 2: Cumulatively count and sum sales values less than $25,000, and incrementally increase the value by $25,000 and repeat the calculations until you reach to $300,000. cumulative- count cumulative- sum $25,000 $50,000 $300,000
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