Importing Data - The Complete Course in All File Types and Data Tricks to Get Your Data Ready for Analysis This course will teach you to import, combine, and define various types of data into IDEA Software TM and understand the difference between the tables and implications for the import process.
![Idea Data Analysis Software Workbook Idea Data Analysis Software Workbook](https://www.casewareanalytics.com/sites/default/files/uploads/smartanalyzer_10_brochure.png)
Eleven Excel workbooks can be downloaded for free which contain worksheets that implement the various tests and analyses described in the rest of this website. In parentheses is a list of the Real Statistics website main menu topics covered in each examples workbook. Dear Charles, I’m running the Real Statistics Add-In on Excel 2016 and I’m getting this error message: “Anova: Single Factor – Input range contains non-numeric data.”. I found the issue while following the Example 2 instructions in “but then I noticed that I can replicate the same issue simply pushing “Config” and “OK” after “Ctrl-m”. By the way, thank you very much for the great website!
Best regards, Francesco. Hi Charles, I would like to thank you for the resources. I have downloaded the examples woorkbook but when i have opened the file, it appears error message “Compile error in hidden module: Correlation”, when i click help for information on how i coorect this error, they give me two possible solutions: 1-“If you have access to the VBA code in the document or project, unprotect the module, and then run the code again to view the specific error”. 2-“If you do not have access to the VBA code in the document, then contact the document author to have the code in the hidden module updated”. How i should proceed? Charles, I installed the Real Statistics Multivariate Examples workbook. (I followed your instructions scrupulously).
Then I opened Factor Analysis Principal Component Analysis Teacher Evaluation Example. Most tables are populated with data, but three tables (correlation matrix, eigenvalues and eigenvectors, and reduced model) show the #NAME? Error in each cell. It seems that somehow the functions CORR and eVECTORS are not working. I use Excel 2016 and Windows 10.
Thanks for suggesting a fix. Alan, This means that the Real Statistics Resource Pack has not been installed on your computer. When you press the key sequence Alt-TI, do you see Solver and RealStats on the list of addins with a check mark next to them? If not, the Real Statistics has not been installed. Also when you enter the formula =VER you should see the Real Statistics release number.Please reread the installation instructions written on the webpage from which you downloaded the file containing the Real Statistic software.
Charles I omitted to mention that I had followed your installation instructions carefully, both Solver and RealStats had check marks next to them on the list of addins and, consistent with my earlier posts, the formula =VER also displayed #NAME? I know how difficult it can be to support users with add-ins at the best of times and my regularly updated Windows 10 and Office 2016 seem to be ratcheting up security. Having read, I selected Windows Explorer RealStats.xlam Properties General Unblock. You may need to add this (irreversible per copy of the file) step to your installation instructions. When I subsequently launched Excel, it kept crashing at the splash screen while opening Solver.xlam, until I tried to “open” RealStats.xlam from Windows Explorer. Excel did not crash and =VER displayed 5.2 Excel 2013/2016. However, “opening” RealStats.xlam had disabled Solver.
When I re-enabled Solver, it started to open and immediately crashed Excel. On re-launching Excel, I received the following error message: Microsoft Excel Excel is running into problems with the ‘solver add-in’ add-in. If this keeps happening, disable this add-in and check for available updates. Do you want to disable it now? Yes No I selected No and, again, Excel crashed at the splash screen while opening Solver.xlam.
Unfortunately, with up-to-date and fully-repaired Office 2016 and up-to-date Windows 10 Home, RealStats.xlam and Solver.xlam don’t seem to be mutually compatible. Alan, I am not really sure what is causing this problem. I am not seeing it on my computer. I just had a problem using Real Statistics on my Mac and I followed the following simple steps (translated to the Windows environment) to resolve it: 1.
Opened blank Excel worksheet. Disabled RealStats (i.e. Pressed Alt-TI and unchecked RealStats, leaving Solver checked) 3. Closed Excel 4. Opened blank Excel worksheet.
Enabled Reals (i.e. Pressed Alt-TI and checked RealStats) Everything worked fine after doing these steps, although I don’t know why it worked.
Hi Charles, Thanks for the great resources. I am being tasked with making a bid analysis conducted by a local municipality for a certain product to be used by that particular local city and with it, are the past data where the participating companies are submitting such as prices they bid, the exchange rates, raw material prices among others.
![Idea data analysis software workbook free Idea data analysis software workbook free](https://www.casewareanalytics.com/sites/default/files/uploads/se_3.png)
And based on that analysis, I need to make an appropriate prediction of the next bidding outcome, so we can predict competitor’s pricing based on the historical data so we can plan on how should we bid for us to win the contract. Is the Monte Carlo simulation works well with this task or is there any other appropriate approach?