Does anybody know of an addin for Excel that is able to run a principle component analysis?

More Marcel Rietjens's questions See All

Hyperthermia, electrical or by EM radiation?

Two methods I know of and use are heat induced by means of electromagnetic radiation (microwaves) and through an alternating electrical current (about 10 MHz). In the literature there are papers...

31 December 2018 6,558 1 View

How does the moisture content in the air influence the impact strength of PEEK?

I am working with PEEK and its mechanical properties such as impact strength, ductility etc. The question I have is the influence of moisture on these properties. We observe quite some variation...

04 May 2013 9,179 2 View

How to compare two groups with only two measurements?

Hiiiii everyone! I have an enquiry on statistical analysis. I was looking for many forum and it's still cannot solve my problem. I want to compare means of two groups of data but only with two...

03 March 2021 8,796 3 View

Enhanced Yellow Fluorescent Protein (Aequorea victoria) DNA sequence?

I am on the lookout for the Enhanced Yellow Fluorescent Protein (Aequorea victoria) DNA sequence. Does anyone know where I can find it? Thank you in advance

03 March 2021 3,568 1 View

What kind of fluid could I use for a pitfall trap that also does not invalidate molecular testing?

Hi, I want to start testing pitfall trap to obtain ants samples, but I need to conduct molecular analysis on those insects. So, what kind of fluid can I use? Ethanol expires too early and I need...

03 March 2021 5,978 5 View

What's the best way to measure growth rates in House sparrow chicks from day 2 to day 10?

What's the best way to measure growth rates in House sparrow chicks from day 2 to day 10? Since, the growth curve from day 2 to 10 won't be like the "Logistic curve" it might not follow logistic...

03 March 2021 1,401 3 View

Do we need to write protocol for a second study of a systematic review that has been registered and published?

I have conducted and published a systematic review and meta-analysis research with the topic related to public health and health pomotion (protocol was registed in PROSPERO). Now we want to...

03 March 2021 8,920 3 View

How to increase a model accuracy ?

dear community, my model is based feature extraction from non stationary signals using discrete Wavelet Transform and then using statistical features then machine learning classifiers in order to...

03 March 2021 6,994 5 View

Do I need to do linear regression before running mediation analysis using PROCESS MACRO by Hayes ?

I just wanted to check if I need to run a linear regression separately if I am using PROCESS MACRO to run mediation analysis. Thank you.

02 March 2021 4,359 3 View

Sample dilution for quantitative analysis using ELISA?

If the detection range is in ng/ml but the reference range is in ug/ml for a molecule or protein in serum or plasma .how to dilute and what is the initial volume to be taken for quantitative analysis

02 March 2021 7,670 3 View

Is There Any Feasible Method To Test Fluorescent Compounds Other Than Fluorescence Spectrometers ??

Is There Any Feasible Method To Test The Efficiency Of Fluorescent Compounds Other Than UV Spectrometers ? Suggestions Would Be Appreciated !

02 March 2021 5,785 3 View

How to calculate average trend in maximum annual NDVI from MODIS?

I am wanting to calculate the average trend in maximum annual NDVI in Iceland from 2010-2020 using MODIS MYD13Q1 V6. How would I do this? I have currently inserted the NDVI bands from the MODIS...

02 March 2021 752 2 View

Matthias Templ

another possibiliy is to install RExcel. you can find it easily over the web. It intergrates R in Excel where you can then use the princomp function of R in Excel.

Joachim Brade

Dear Marcel

WinStat is a powerful Excel-Addin. It was designed by a German Software Company. It does mighty analyses including PCA - at least I think. Feel free to google and download a free trial version including manual. The commercial version is rather cheap - around 100 € as I remember, at least this was the price couple of years ago.

Best regards