Microsoft Office Excel

Contact experts in Microsoft Office Excel to get answers

1,499 views 1,194 posts

Questions related to Microsoft Office Excel

How do I parametrize the EMSC model for ATR-FTIR spectra?

To be used for: Biological macromolecules in cells No. of spectra: 18 samples (Spectral range - 600 - 3600 cm-1) Looking for implementation in the 'UNSCRAMBLER' software. (looking for model...

11 May 2020 305 0 View

How can I convert RNA-seq data (normalized read count and differentially expressed genes data in Excel format) in presentable graphical format?

I simply wanted to compare differentially expressed genes between 2 types of tissues using RNA-seq. Following, data was processed by a Bioinformatics person and provided 2 types of Excel...

03 May 2020 4,957 2 View

Looking for a way to force regression through one of five calibration levels?

Hello community, I'm currently working on a fluorescence based assay and experience recovery issues in my samples at low analyte levels. I noticed big residual deviations from the lowest...

02 May 2020 5,579 3 View

How to convert frequency-amplitude data to time-amplitude data using inverse fourier transform?

Hello, I have data in an Excel spreadsheet that is in terms of frequency and amplitude. I want to convert this into time and amplitude using an inverse Fourier transform. What script could I use...

01 May 2020 4,694 4 View

Why can't we have non-normal residual in regression analysis and still have no issues with the predictive model?

The non-normality of residual can be justified though the linearity and bias as the linearity also has similar logic. Can you please throw more light on this?

30 April 2020 7,589 3 View

What is the best treatment processes applied in nitrate removal from groundwater for drinking water supplies?

Currently, nitrate is a major water pollutant in many areas of world, such as Saudi Arabia, India, the UK, North America, Australia, Algeria, Morocco, in China, and Iran. In my research work on...

15 April 2020 3,527 12 View

How to calculate error of a ratio of two data with errors?

Suppose I need to calculate A =(B/C), where B= 1.00+- 0.33 and C= 1.50+- 0.43 How do I calculate the error of A? as in, A=0.66+- ? Any idea if I can do this in excel or any other...

14 April 2020 7,876 3 View

How do you calculate Moran's I in Excel?

29 March 2020 2,063 3 View

How to add Creative Commons License code to a Google Sheet?

Dear Experts, Please help me to know ho to add Creative Commons License Code to one of my learning tool that i created using Google Sheet / Microsoft Excel. Please...

21 March 2020 9,715 4 View

Why is data which appears to be skewed apparently normal?

I am trying to statistically answer whether these two data sets have normal distribution. It seems obvious from the bar chart which I created in Excel that they do not, but I've attempted a...

18 March 2020 5,325 3 View

What is the best way to transfer and catalogue samples from a lab member who is leaving?

I am taking over a project from a post-doc who is departing the lab at the end of the month. I've been instructed to move his samples to my boxes. I want to do this in a way that makes it easy to...

06 March 2020 5,948 1 View

Do you know any Excel prepared for probabilistic sampling?

There is software that could be used to do the sampling, but maybe someone has developed any Excel sheet to do the process easily. I would like to do a multi-stage including principally clusters...

06 March 2020 6,752 3 View

Application of ordinal logistic regression models in construction industry?

I am looking up the application of ordinal logistic regression models in construction industry supported by excel tables calculations for odd ratios and cumulative probabilities as well as how to...

04 March 2020 7,829 3 View

Does anybody have experience using PGI Fortran DLLs from VBA (Excel x64)?

I am using Fortran DLLs together with VBA Excel since many years. The configuration so far was Windows 7 (x32), Excel 2013 (x32) and MS Developer Studio Fortran PowerStation 4.0 (1994!) also x32....

22 February 2020 9,331 9 View

Can anyone help me to find an excellent task for block design in fMRI to diagnose AD patients?

any Articles, descriptions or projects

14 February 2020 9,780 3 View

I want a gray excel dematel file. Can anyone help me?

I want to find the relationships between a number of variables that are classified into eight categories. I need the gray demetel technique written in Excel.

11 February 2020 824 2 View

What is the fate of bioaccumulated bacteria in 70% ethanol preserved filter feeders (bivalve)?

Bivalve specimens are preserved in 70% ethanol for about 6 months. What is possibility of being able to extract DNA/RNA of bacteria that was previously consumed?

04 February 2020 5,938 5 View

Good day, can someone assist me with a Microsoft Excel sheet format of Penman-Montheith FAO-56 calculator?

The Microsoft Excel sheet format of Penman-Montheith FAO-56 calculator is required for computing the Reference Evapotranspiration of the south-south region of Nigeria, using four monthly...

27 January 2020 5,237 3 View

How to fit linear-plateau curve in excel?

I have sort of data consist of two variables --dependent and independent-- and want to fit it in linear-plateau form. How to do that in excel or other software and how to identify the inflection...

21 January 2020 1,394 3 View

Help with VBA code for Gauss elimination?

Colleagues, I wrote VBA code for function of Gauss elimination (in attached files). But I can't launch this function in Excel. I can't find it by her name in line for function's input. Could...

20 January 2020 5,408 5 View

How to input multiple conditions in excel IF nested function?

Hi community, I am facing some issues to input the conditions when I use the IF formula. Can anyone please enlighten me on this? So far, I have this formula, =IF(B1

20 January 2020 7,689 2 View

How can I export data (csv) from scopus effecient to an excel table?

Hey community i have a question for you. Im doing a literature review and i want to put the relevant literature in an excel table to check it later. Whenever i am exporting something in CSV (using...

14 January 2020 6,253 3 View

Bibliometrix Data Entry in R-Language?

Bibliometrix software R accepts data from Web of Science & Scopus. Can we download data to Excel to remove non-relevant articles, convert into text and upload to R for analysis?

13 January 2020 796 7 View

Why is excel convert function from tbs to gm not working?

hello, I wanted to convert tablespoon measurements into grams in excel (for a whole column), however, it didn't work and gave me an error, so is there any way to convert liquid measurements to...

11 January 2020 3,120 1 View

Badges
Science topic