Click on an icon below for a free download of either of the following files.: contains a variety of supplemental functions and data analysis tools not provided by Excel. These complement the standard Excel capabilities and make it easier for you to perform the statistical analyses described in the rest of this website.: four Excel workbooks can be downloaded for free, which contain worksheets that implement the various tests and analyses described in the rest of this website. Two files cover univariate tests and the other two cover multivariate tests and time series analysis.
Outline Materi. Statistik Parametrik dan Non Parametrik. Pengujian Normalitas Data, t-test, Korelasi. Product Moment. Analisis Regresi Sederhana. R 005.265 BUK BUKU latihan SPSS statistik parametrik / Singgih.
Real Statistics Analysis using Excel books: Shortly you will be able to purchase books that will contain information that is similar to what you find in the website. The first of these books is expected to be available in early 2017. Zaiontz: Thank you so much for making this wonder set of statistical tools accessible.
I work for a small non profit whose mission is to improve instruction in elementary and middle school mathematics classrooms around the country. Part of my role is to support school districts and schools in their program evaluation efforts. Your Real Statistics Resource Pack makes basic program evaluation much more accessible since most districts already have access to Excel. Your work is making a difference!
Sincerely, Pam Tabor Research and Evaluation Specialist US Math Recovery Council. Hello Sir, Thank you for your site, very useful. I’m also encountering compatibility issues. I’m running in Windows 10 (64bit) and have recently updated to the Fall Creators Update.
It’s my first time to try your real stat add-in though, so I have no comparison with the other versions of Windows 10. I’m using Excel 2016.
I was able to install the add-in just fine. Solver add-in is also installed. But when I try to use any of your functions, KCORREL for example an error appears: “Compile error in hidden module: Correlation. This error commonly occurs when code is incompatible with the version, platform, or architecture of this application.” With the add-in installed, I encounter “Automation Error” pop-up everytime I open the Excel.
I also did the troubleshooting instructions mentioned but didn’t work. Hi Charles, I found out that it’s the solver add-in that’s causing the error. I’ve seen many people raised that issue over the internet but has yet to be resolved.
Anyway I was able to run your add-in on a different machine. However, I was getting the KCORREL for 2 columns (18,000 rows). It was able to compute for the kcorrel, but when I invert the order of the columns, say KCORREL(B,A) instead of KCORREL(A,B), I get #VALUE as the result.
Shouldn’t it be somewhat commutative, I mean not order-specific? So I am expecting the same result when I do KCORREL(A,B) and KCORREL(B,A).
Thanks a lot! Charles; I hope you are well. I sure you would help me, where I have a statistical problem as follow: I have 2 populations, 1st is a health providers at 2 hospitals (supervisory staff) with total sample size of (328 person) and the 2nd population is the in-patient at the same 2 hospitals with total sample size of (540 pts.). 2 surveys was used to collect the data, one survey for each population, the 1st one (with 68 questions) for the 1st population used to measure the level of using Six Sigma Methodology (DMAIC) at 2 hospitals, and 2nd one (with 36 questions) for the 2nd population that used to measure the level of patient’s satisfaction under light of using Six Sigma Methodology (DMAIC) at the same 2 hospitals.
Both surveys has the same 5 dimensions (DMAIC) with same Likert Scale (5 scale), the data was collected at the same times. There are difference in questions no.
Between the 2 surveys, but there are (13) similar questions in every survey. N.B: The surveyed (male and female) pts are from several ward (medical, surgery and obstetric wards), also most of health provider (male and female) are from these wards. I need to find the effect or association (correlation) between the level of using Six Sigma Methodology (DMAIC) as (X variable) and the level of patient’s satisfaction under light of using Six Sigma Methodology (DMAIC) as (Y variable) using the data that collected as mentioned above.
So I do the following: 1. Assuming that, level of pt. Satisfaction is the Y variable, so I fixed every pt.’s case score (average mean for every dimension and total mean score), then we have 540 pts.
With (6 scores for every one). Also I assuming that, level of Using Six Sigma Methodology (DMAIC) is the X variable, then I measure the score for every health provider case (total of 328 person), so I have 6 scores for every one (average mean for every 5 dimensions and total mean score). Using bootstrapping technique to generate random samples form the scores of health provider cases that every random sample contain (10) cases of them together which starting with a certain generated no. And calculate the scores, then return back the cases for the origin samples. Repeat previous step (3) starting with a new generated no. To be sure not repeat the same generated random sample. With step (3) and (4), using bootstrap, so we have (1000) random samples for each (540) pt.
From the previous steps we will calculate the correlation between (X) and (Y). My question is that: Is this procedure right to calculate the association between X and Y?, if Yes, which test can I used to perform it?, if No, How to do this right? Or I must measure the overall level of using Six Sigma Methodology as will as the pt.’s satisfaction in each ward of hospital alone then match them and do the bootstrap, or do it by gender in every ward then match them as: Overall score of female (Health provider) in surgery ward (X variable), attach with overall score of female (inpatients) in surgery ward (Y variable). And overall score of male (Health provider) in surgery ward (X variable), attach with overall score of male (inpatients) in surgery ward (Y variable). Also the medical and other ward the same as previous.
I’m looking for your kind answer. Best regards. Thanks for the Response. I have replaced as suggested in entire workbook still problem persists. For eg the formula bar on clicking the cell with #Name?
Shows =RESHAPE(A5:C8). I tried to copy the Input range from somewhere else in sheet and write corresponding output formula in other cell but still its giving #Name?I am using Excel 2013. To me it looks to issue in loading of RealStats.xlam functions as when I click the cell with #Name? It shows =RESHAPE(A5:C8) in formula bar and now select Insert Function, the function popup shows the name RESHAPE with parameters but below it writes undefined.