Question: Questions for the assignment: (1) Which statistical analysis and Excel function will be very useful in finding the patterns in the data? Why? (2)Which tools/analysis

Questions for the assignment:

(1) Which statistical analysis and Excel function will be very useful in finding the patterns in the data? Why?

(2)Which tools/analysis in the BI lecture will provide Mary the best value? Why?

Tasks:

(1) Please perform at least two types of data analysis in EXCEL, and insert spreadsheets to show those analysis;

(2) Summarize your data analysis results in 2-3 paragraphs to respond to the two questions listed above, and include your paragraphs of summary in the EXCEL file, on the Questions sheet. Questions for the assignment: (1) Which

Quantity Sold 2 2 7 2 1 Garden Size Small Large Small Large Small Small Small Small Large Small Large 2 1 1 5 3 3 5 Large 2 3 5 3 Small Medium Medium Medium Small Medium Small Small Medium Medium Large Large 2 2 2 2 4 5 5 1 7 9 Large 9 Jay 2 4 Transaction Number Last Name First Name 4 Bibb Robin 5 Rodman Johnny 3 Angelo Donatica 1 Enriquez Antonio 2 Carder Vicky 6 Matchtoff 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 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 37 Henning Patricia 38 Rhames Sherman Emmett 40 Roach Marcie 41 Hughes Frank 42 Matchtolff Allean 43 Macnai Leigh Ann 44 Porterfield Jimmy 45 Hauch Joann 46 Ruaz Monica 47 Mensik Ronald 48 Reyes Rayna 49 Carder Vicky 50 Gauger Samone 51 Angelo Donatica 52 Mallouf Pedro 53 Yereshenko Zee 54 Wakefield Lorraine 55 Fiddes Rick 56 Lester James 57 Mazza Pamela 58 Tickner Rex 59 Bourque Elizabeth 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 (972)380-3202 (972)380-4789 (972)380-4776 (972)380-2792 (972)380-2794 (972)380-5595 (972)380-5710 (972)380-2795 (972)380-2796 (972)380-2792 (972)380-3201 (972)380-5597 (972)380-2796 (972)380-5712 (972)380-5597 (972)380-3203 (972)380-3204 (972)380-5712 (972)380-5598 (972)380-3203 (972)380-5599 (972)380-5598 (972)380-5713 4 5 3 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 $80.04 $16.50 $86.18 $90.79 $88.90 $171.00 $256.50 $99.00 $103.56 $36.00 $375.00 $111.75 $14.95 $120.90 $80.30 $129.61 $36.00 $70.50 $134.98 $528.45 $135.00 $390.29 $150.18 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 Outdoor Plant Outdoor Plant Outdoor Plant Outdoor Plant Outdoor Plant Garden Tool Outdoor Plant Outdoor Plant Garden Tool Outdoor Plant Garden Tool Outdoor Plant Plant Seeds Outdoor Plant Outdoor Plant Garden Tool Plant Seeds Outdoor Plant Outdoor Plant Outdoor Plant Outdoor Plant Outdoor Plant Outdoor Plant 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 19-Feb-18 20-Feb-18 20-Feb-18 21-Feb-18 21-Feb-18 22-Feb-18 22-Feb-18 22-Feb-18 22-Feb-18 22-Feb-18 1-Mar-18 1-Mar-18 2-Mar-18 2-Mar-18 3-Mar-18 3-Mar-18 3-Mar-18 4-Mar-18 4-Mar-18 5-Mar-18 5-Mar-18 6-Mar-18 6-Mar-18 1 1 2 wa 2 5 4 4 1 8 2 Small Small Small Large Small Medium Large Medium Small Large Small Medium Small Small Medium Large Small Small Medium Small Small Small Medium Small Small Small Small Large Small Large Medium Small Medium Small 39 Nigel 5 12 4 2 12 8 2 4 5 8 12 6 2 4 4 2 2 8 12 5 12 8

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!

Week 5 Lecture 13 This week we look at two different approaches to analyzing data and making inferences about the populations they come from. The first is confidence intervals, a range of values that...

Submitted to Management Science manuscript MS-0001-1922.65 Authors are encouraged to submit new papers to INFORMS journals by means of a style file template, which includes the journal title....

contributed articles DOI:10.1145/ 2602574 How to use, and influence, consumer social communications to improve business performance, reputation, and profit. BY WEIGUO FAN AND MICHAEL D. GORDON The...

1.1 INTRODUCTION Reliable statistics are required for efficient national development. It provides governments, corporations, and civil society with the information they need to make educated policy,...

HI, PLEASE I WOULD LIKE TO GET ANSWER FOR THESE QUESTIONS IN EXCEL IT IS NO NECESSARY TO WRITE BY HAND. Please use Excel for statistical analysis. Relevant Excel statistical output must be properly...

HI, PLEASE I WOULD LIKE TO GET ANSWER FOR THESE QUESTIONS Please use Excel for statistical analysis. Relevant Excel statistical output must be properly analysed and interpreted. ( EXCEL IN THIS LINK...

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?...

UTS Business Statistics 26134 Report (Group Assignment) SPRING 2017 Assessment Value: This assignment is worth 20% It is be completed in: A GROUP OF 3, 4 or 5 STUDENTS Due times and dates: Due...

Consider our group of 5 people from Exercise 51. a) How many lefties do you expect? b) With what standard deviation? c) If we keep picking people until we find a lefty, how long do you expect it will...

Why is account classification a preferred method for estimating costs when submitting a proposal for grant funding? For example, a not-for-profit organization might apply to the Gates Foundation for...

Under what circumstances will you use a positioner? List any four.

Case Greenbuilders Pte Lid ("GPL") is a local construction company which specialises in providing bespoke Design and Build construction services for private residential homes that are designed to be...