I need formulas shown if it applies in excel

Question 1You are the owner of a taco franchise chain (named "Taco Tuesday") that has locations in all the counties of California.Data on the number of taco sales by type in a given month in each county is given in the tab "Taco Data"The table also reports the population of each county.This question asks you to imagine selecting a county at random from the list

1.1What was the expected amount of Beef Taco sales in a randomly selected county this month$

1.2Complete the below probability table of the likelihood that a county selected at random is in one of the following bins

X XP(X)

Less than 101 Fish Tacos Sold

101-500 Fish Tacos Sold

501-600 Fish Tacos Sold

More than 600 Fish Tacos Sold0

1.3Calculate the following conditional and unconditional probabilities of selecting a county of the following types at random,where

A = Population of a county is greater than 1,000,000

B = The county has more than 500 Beef Taco Sales

C = The county has more than 400 Fish Taco Sales

D= The population of a county is less than 200,000

Probability to Calculate Solution

P(A)

P(B)

P(A or D)

P(A and D)

P(B|C)

P(B|D)

P(B and C)

1.4Answer whether the following pairs of events are mutually exclusive or statistically independent:

Events: Are these Mutually Exclusive? Are these Statistically Independent?

A and D

B and D

B and C

CountyCounty Population Sales of Beef Tacos Sales of Fish Tacos

Alameda County 1671329 597 489

Alpine County 1129 516 403

Amador County. 39752 596 447

Butte County 219186 438 348

Calaveras County 45905 523 410

Colusa County 21547 495 316

Contra Costa County 1153526 611 489

Del Norte County 27812 442 279

El Dorado County 192843 510 348

Fresno County 999101 535 362

Glenn County 28393 473 417

Humboldt County 135558 439 453

Imperial County 181215 479 454

Inyo County 18039 532 350

Kern County 900202 480 479

Kings County 152940 505 399

Lake County 64386 484 365

Lassen County 30573 485 386

Los Angeles County. 10039107 475 308

Madera County 157327 516 409

Marin County 258826 491 333

Mariposa County 17203 514 530

Mendocino County 86749 444 337

Merced County 277680 530 378

Modoc County 8841 527 399

Mono County 14444 472 471

Monterey County 434061 543 456

Napa County 137744 488 430

Nevada County 99755 439 384

Orange County 3175692 459 510

Placer County 398329 413 500

Plumas County 18807 508 474

Riverside County 2470546 508 403

Sacramento County 1552058 434 331

San Benito County 62808 534 338

San Bernardino County 2180085 525 387

San Diego County 3338330 524 592

San Francisco 881549 485 360

San Joaquin County 762148 490 391

San Luis Obispo County 283111 510 391

San Mateo County 766573 537 482

Santa Barbara County 446499 480 486

Santa Clara County 1927852 543 401

Santa Cruz County 273213 481 455

Shasta County 180080 453 610

Sierra County 3005 535 346

Siskiyou County 43539 535 456

Solano County 447643 483 342

Sonoma County 494336 550 370

Stanislaus County 550660 468 384

Sutter County 96971 490 550

Tehama County 65084 543 366

Trinity County 12285 417 512

Tulare County 466195 433 467

Tuolumne County 54478 496 415

Ventura County 846006 520 451

Yolo County 220500 584 397

Yuba County 78668 575 489