Weka an Excel for data mining

i have a text file an i want someone to 1) Using excel, create a BAR chart (similar to the figure below) which will display the frequency distributions of items sold in transactions. • Because the dataset is huge, use Excel capabilities to help you in this task: the command “Remove Duplicate” (in the Data Tab), the Excel function CountIF which counts the number of cells that meet a certain condition, etc. 2) Load your assigned dataset into Weka and explore it. 3) Report any preprocessing you will make in order to prepare for a market-basket analysis. 4) Report the most important experiments you will make related to the setting of the Apriori’s parameter values and how you will proceed to reach your optimal configuration. • We will consider an optimal configuration as the one which delivers some FEW strong rules. 5) Discuss the found association rules, obtained using your optimal parameter values, in terms of their significance or interesting associations (ex. uninteresting/interesting, un-useful/useful, unexpected/expected, unobvious/obvious, etc.) 6) Could you have predicted these results based only on the bar chart obtained in 1? 7) Suppose that you are requested to give some recommendations to the hypermarket board that may help them to increase their sales. What are the main recommendations you’ll provide to them?