1. How do I find the average yards gained per day by each time in running and passing using Excel? I cannot change the original data.

2. What would the formula be using character strings to extract only the state from each row?

Yards Run Pass Play type run run pass run pass pass pass Team 5 New England Patriots 2 Denver Broncos 0 Arizona Cardinals 0 34 15 13 . 5 3 2 run 1 Team 2 New England Patriots 3 Arizona Cardinals 4 Arizona Cardinals 5 New England Patriots 6 Denver Broncos 7 New England Patriots 8 Denver Broncos 9 Arizona Cardinals 10 Denver Broncos 11 New England Patriots 12 Arizona Cardinals 13 Denver Broncos 14 Arizona Cardinals 15 Arizona Cardinals 16 New England Patriots 17 Denver Broncos 18 New England Patriots 19 2. run run run pass 2 0 3 run pass LO run 11 1 pass 0 pass 2 3628 Circle East, Richmond VA 37243 122 Us Hwy 78 West, Indianapolis IN 23476 440 Odon Street, Mary CT 3354 293 Howard Road ,Cleveland OH 99336 860 Route 1, Memphis TN 44710