How can I use Microsoft excel to compute ANOVA computations? I have a data set that I would like to know how to go about this in excel. Can I use this package to compute correlations too? how do I arrange my data set and what other analysis tools does this package offer?

Why does the conditional validation rule fail to restrict the rule set? I need to compare the current cell against the value returned by a function. I use this formula to prevent a person using the workbook from entering a date that falls on a weekend:” = (WEEKDAY(C4)<>2, WEEKDAY(C4)<>7)”. If C4 is the cell that containthe validation rule, What prevents the formula from forcing C4 to adhere to both restrictions?

Why is Microsoft Excel always corrupting my XML file? My work required that I import a lot of XML files to Microsoft Excel for analysis, after the successful mapping of the XML file using excel, but when I tried to import the file, I got the message that the file is corrupt. When I check the XML file using XML editor, the files seem to the okay. What can I do to import this file to excel without it being corrupted?

Why is my Microsoft Excel 2013 not having power pivot add inn? I recently need to do some large data analysis using Microsoft excel power pivot, but when I check to enable the add inn, I was unable to find the add inn in the excel COM add inn. my friend that has the same excel 2013 on his laptop has power pivot add inn.

What is the maximum number of rows and columns in a standard worksheet in Excel? Can I increase the number of rows or columns more than the standard available number? Can I create a database in Excel? If not, what is the option for me to use a database within Excel? What can I do to make this possible?ca