Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Q1: When presented with data like this, which statistical analysis and excel functions (Graphs, bar charts, plots, pivot table, functions, etc.) will be useful to
Q1: When presented with data like this, which statistical analysis and excel functions (Graphs, bar charts, plots, pivot table, functions, etc.) will be useful to help find patterns in the data? Why?
(This is not the full excel data sheet, but the question is just asking what sort of analysis would I go about doing if I were to find specific patterns within this data) In terms of solving it, I'd like to know what analysis/functions I can use in another spreadsheet and what cells to use to find patterns within the data.
A B B D E F H Quantity Sold 2 2 7 2 1 2 1 1 5 3 5 2 | | 3 3 Transaction Number Last Name First Name 4 Bibb Robin 5 Rodman Johnny 3 Angelo Donatica 1 Enriquez Antonio 2 Carder Vicky 6 Matchtolff Allean 7 Macnai Leigh Ann 8 Mensik Ronald 9 D'Amico Donald 10 Brunhoeber Robert 11 Lou Chia-Yi 12 Goertzen Keith 13 Darr Kevin 14 Estrada Terrance 15 Thompson Samuel 16 Westvang Harry 17 Wakefield Lorraine 18 Lester James 19 Montague Carmen 20 McMath Olivia 21 Reyes Rayna 22 Tickner Rex 23 Timanus Deona 24 Yates Gayle 25 Yereshenko Zee 26 Wilson Jay 27 Stone David 28 Roselius Reginald 29 Deyoe Rayundo 30 Rhames Sherman 31 Roach Marcie 32 Fees Brenda 33 Hendrix Becky 34 Bolyard Pat 35 Freeman Jerry 36 Langston Kim garden_sale Questions Phone (972)380-4789 (972)380-2792 (972)380-5597 (972)380-2794 (972)380-2796 (972)380-5595 (972)380-5710 (972)380-3201 (972)380-2795 (972)380-5711 (972)380-3202 (972)380-2793 (972)380-5596 (972)380-4776 (972)380-4788 (972)380-4777 (972)380-5712 (972)380-3203 (972)380-5595 (972)380-5710 (972)380-5597 (972)380-5598 (972)380-5599 (972)380-5713 (972)380-3204 (972)380-3201 (972)380-4788 (972)380-4777 (972)380-2793 (972)380-4789 (972)380-2792 (972)380-3734 (972)380-1333 (972)380-5596 (972)380-5711 (972)380-5594 Garden Size Small Large Small Large Small Small Small Small Large Small Large Large Small Medium Medium Medium Small Medium Small Small Medium Medium Large Large Large Small Small Small Large Small Medium Large Medium Small Large Small NNN G Total Amount Paid $14.50 $19.99 $8.05 $271.00 $75.00 $70.50 $40.65 $22.33 $862.50 $16.50 $7.50 $250.50 $28.50 $4.45 $265.60 $125.00 $80.30 $70.50 $36.79 $39.35 $69.00 $40.65 $156.31 $496.80 $562.50 $45.70 $49.06 $59.75 $46.08 $6.45 $40.15 $250.50 $19.00 $71.86 $78.47 $5.50 Product Category Plant Seeds Plant Seeds Plant Seeds Outdoor Plant Garden Tool Outdoor Plant Outdoor Plant Outdoor Plant Garden Tool Outdoor Plant Plant Seeds Garden Tool Outdoor Plant Plant Seeds Garden Tool Outdoor Plant Garden Tool Outdoor Plant Outdoor Plant Outdoor Plant Outdoor Plant Garden Tool Outdoor Plant Outdoor Plant Outdoor Plant Outdoor Plant Outdoor Plant Outdoor Plant Plant Seeds Plant Seeds Garden Tool Garden Tool Outdoor Plant Outdoor Plant Outdoor Plant Plant Seeds Sales Date 2-Jan-18 2-Jan-18 3-Jan-18 3-Jan-18 3-Jan-18 5-Jan-18 5-Jan-18 5-Jan-18 6-Jan-18 7-Jan-18 8-Jan-18 9-Jan-18 9-Jan-18 25-Jan-18 27-Jan-18 27-Jan-18 1-Feb-18 1-Feb-18 1-Feb-18 1-Feb-18 1-Feb-18 3-Feb-18 3-Feb-18 3-Feb-18 3-Feb-18 3-Feb-18 3-Feb-18 3-Feb-18 3-Feb-18 5-Feb-18 5-Feb-18 18-Feb-18 18-Feb-18 18-Feb-18 18-Feb-18 19-Feb-18 2 4 U 1 7 9 2 4 4 5 3 1 2 2 5 4 1 A B B D E F H Quantity Sold 2 2 7 2 1 2 1 1 5 3 5 2 | | 3 3 Transaction Number Last Name First Name 4 Bibb Robin 5 Rodman Johnny 3 Angelo Donatica 1 Enriquez Antonio 2 Carder Vicky 6 Matchtolff Allean 7 Macnai Leigh Ann 8 Mensik Ronald 9 D'Amico Donald 10 Brunhoeber Robert 11 Lou Chia-Yi 12 Goertzen Keith 13 Darr Kevin 14 Estrada Terrance 15 Thompson Samuel 16 Westvang Harry 17 Wakefield Lorraine 18 Lester James 19 Montague Carmen 20 McMath Olivia 21 Reyes Rayna 22 Tickner Rex 23 Timanus Deona 24 Yates Gayle 25 Yereshenko Zee 26 Wilson Jay 27 Stone David 28 Roselius Reginald 29 Deyoe Rayundo 30 Rhames Sherman 31 Roach Marcie 32 Fees Brenda 33 Hendrix Becky 34 Bolyard Pat 35 Freeman Jerry 36 Langston Kim garden_sale Questions Phone (972)380-4789 (972)380-2792 (972)380-5597 (972)380-2794 (972)380-2796 (972)380-5595 (972)380-5710 (972)380-3201 (972)380-2795 (972)380-5711 (972)380-3202 (972)380-2793 (972)380-5596 (972)380-4776 (972)380-4788 (972)380-4777 (972)380-5712 (972)380-3203 (972)380-5595 (972)380-5710 (972)380-5597 (972)380-5598 (972)380-5599 (972)380-5713 (972)380-3204 (972)380-3201 (972)380-4788 (972)380-4777 (972)380-2793 (972)380-4789 (972)380-2792 (972)380-3734 (972)380-1333 (972)380-5596 (972)380-5711 (972)380-5594 Garden Size Small Large Small Large Small Small Small Small Large Small Large Large Small Medium Medium Medium Small Medium Small Small Medium Medium Large Large Large Small Small Small Large Small Medium Large Medium Small Large Small NNN G Total Amount Paid $14.50 $19.99 $8.05 $271.00 $75.00 $70.50 $40.65 $22.33 $862.50 $16.50 $7.50 $250.50 $28.50 $4.45 $265.60 $125.00 $80.30 $70.50 $36.79 $39.35 $69.00 $40.65 $156.31 $496.80 $562.50 $45.70 $49.06 $59.75 $46.08 $6.45 $40.15 $250.50 $19.00 $71.86 $78.47 $5.50 Product Category Plant Seeds Plant Seeds Plant Seeds Outdoor Plant Garden Tool Outdoor Plant Outdoor Plant Outdoor Plant Garden Tool Outdoor Plant Plant Seeds Garden Tool Outdoor Plant Plant Seeds Garden Tool Outdoor Plant Garden Tool Outdoor Plant Outdoor Plant Outdoor Plant Outdoor Plant Garden Tool Outdoor Plant Outdoor Plant Outdoor Plant Outdoor Plant Outdoor Plant Outdoor Plant Plant Seeds Plant Seeds Garden Tool Garden Tool Outdoor Plant Outdoor Plant Outdoor Plant Plant Seeds Sales Date 2-Jan-18 2-Jan-18 3-Jan-18 3-Jan-18 3-Jan-18 5-Jan-18 5-Jan-18 5-Jan-18 6-Jan-18 7-Jan-18 8-Jan-18 9-Jan-18 9-Jan-18 25-Jan-18 27-Jan-18 27-Jan-18 1-Feb-18 1-Feb-18 1-Feb-18 1-Feb-18 1-Feb-18 3-Feb-18 3-Feb-18 3-Feb-18 3-Feb-18 3-Feb-18 3-Feb-18 3-Feb-18 3-Feb-18 5-Feb-18 5-Feb-18 18-Feb-18 18-Feb-18 18-Feb-18 18-Feb-18 19-Feb-18 2 4 U 1 7 9 2 4 4 5 3 1 2 2 5 4 1Step 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