Microsoft Office Excel

Contact experts in Microsoft Office Excel to get answers

1,328 views 1,194 posts

Questions related to Microsoft Office Excel

How can I calculate Standard Deviation using DataWarrior?

I am analyzing about 500 results in DataWarrior and I need to calculate the mean value and the SD. I managed to calculate the mean value using excel, but it I couln't find a way to simply...

26 October 2020 9,489 3 View

How can I estimate/ calculate evapotranspiration from Landsat 8 or Sentinel 2 imageries?

I am working on two projects that both require me to estimate Evapotraspiration in my areas of interest. The first project is to calculate ET in rice fields (in a controlled field and in a local...

24 October 2020 8,052 3 View

Splitting data into different but equal random samples in excel?

I have 3 data sets (eg Scores from three different Universities) all mixed up in a single excel sheet and with different number of scores. Eg Oxford sample with 4000 scores, Cambridge with 3200...

23 October 2020 8,090 7 View

Excel formula for assigning grade?

I have a excel sheet with positive and negative value. I have 4 grades to be assigned. How can I use a formula to assign the grades? I have tried using the IF nested function but due to negative...

22 October 2020 5,760 7 View

Can I analyse NGS DATA from an EXCEL spreadsheet?

Hi, I have Fold expression of RNAseq data obtained from Ion Proton sequencer and got the fold change data with mean in an excel sheet. now can I analyse this fold change data using any...

21 October 2020 2,448 3 View

Working with nominal data in Excel / Stat plus, Chi square?

We are analyzing the response of >400 respondents to a survey, with values of -1 (no) 0 (neutral), and +1 (yes). The data were collected to assess opinions on feeding practices at zoos. An...

18 October 2020 1,130 2 View

When a person walks on a force plate with self selected speed, What solutions are there to normalize force plate data?

(to better compare subject with each other ...)

15 October 2020 5,656 6 View

Is there any data available for land use/land use change and Forestry (LU/LUCF) for South Asia?

I need land use (forestry, farmland, rangeland, glaciers, waterbodies, barren regions, settlements) dataset for a project. I need it as baseline/ observational data for historical changes in land...

12 October 2020 5,211 3 View

How to create a surface plot and contour? If i have an excel file with X, Y ,Z values of the surface ( Periphery of a tube) and Q (heat flux) value.?

Need to create 3d surface plot. Data I have X, Y ,Z coordinate of the pipe surface and the corresponding Q (heat flux) values at that point. Nearly 222440 data points of a 2m length pipe. Thank you

08 October 2020 10,081 7 View

Calcul Max (Stress, Strain) In Excel?

Dear researchers, I performed mechanical tensile tests and obtained results in the form of two columns (force in N, displacement in mm) after I calculated (stress in MPa, strain %). I would like...

06 October 2020 3,251 2 View

What is the degree or extent to which the person conforms to the requirements and needs of the human being?

It requires conformity to human requirements and needs, The existence of a familiar product object that has a meaning or substance. And when excellence and creativity are an inherent...

05 October 2020 9,889 1 View

I have used Whoqol-Bref in my research. As there are two transformation methods 4-20 and 0-100.Which one should be used for the analysis ?

I am confused between two transformation methods of whoqol-bref i.e. 4-20 and 0-100. which scores should I use in the analysis of results ? Please let me know. Thanks

29 September 2020 4,154 1 View

How to set up rheological model (CA and CAM) ?

how to set up asphalt rheological model (CA and CAM) ? How to build EXCEL?

24 September 2020 7,848 2 View

Is it possible to download all publications from the MGH IHP onto and excel spreadsheet?

We are trying to keep track of the MGH IHP Research publication record. We wanted to find a way to track and download the publications onto an excel spreadsheet without having to do it manually.

23 September 2020 8,517 1 View

Using: LabVIEW, DASYLab, Excel, or DIAdem--What is the easiest way to evaluate a signal vs time graph, to determine if the trace falls within limits?

I am making a test request template for product engineers to fill out. The template will basically configure the product, and will prompt the user for nominal values and limits of each variable...

17 September 2020 4,975 2 View

How to merge more than one excel columns of different cell sizes and get a new column without duplicated cells using the R program?

I would like to merge four columns (column1, column2, column3, and column4) and make a new column without duplicated cells. I have attached the excel sheet. Please provide the R scripts to solve...

16 September 2020 2,877 10 View

How do I retrieve the level series back from the differenced series?

I estimate a variable x from a differenced equation such that x is attained in its first differences. But now I need this variable in its levels. Could someone please suggest me how to do so? If...

10 September 2020 4,686 3 View

How to convert, excel files into (.vgd) or (.vms), ( .dts), (.dpr), (.vgl) files ?. Is there any software is available for this conversion?

I need a compatible file with Avantage for XPS of Themo Scientific but y only have excel files (.xls)

08 September 2020 638 3 View

Find Equivalent data from log scale?

Hi. I have a series of data in excel and plot (the column 2 as t and column 6 as y) them in log scale. There is a point on diagram which the logt=100. How can i find the orriginal data that is...

04 September 2020 4,510 2 View

How to draw a operating window to demonstrate the bioreactor performance?

I would like to make a operating window for a bioreactor process where I want to incorporate data such as impeller speed, gas flow rate, hydrodynamic shear, mass transfer efficiency, power...

02 September 2020 2,600 3 View

SPSS: how to approach the import of csv, multi response question and code response names?

Hi, I have exported csv file from sogosurvey, however the free version doesn't allow other file formats, so i had to redefine survey questions into one name variables in excel, then use it in...

26 August 2020 5,542 1 View

How to calculate various constants used in the Herschel Bulky model from exp data (shear stress vs shear rate) to elaborate flow type of fluids ?

How to calculate various constants like consistency index and flow behavior index, used in the Herschel Bulky model from exp data (shear stress vs shear rate) in Origin or excel? If I need to...

23 August 2020 9,091 7 View

Vegan R package and MicrobiomeAnalyst web using biom table from Qiime2?

I got a biom table resulted after running Dada2 in Qiime2. Now I want to analyse the microbiome using the Vegan package for R. In addition I would like to use the MicrobiomeAnalyst web server...

23 August 2020 3,326 1 View

How to analyze statistical differences between samples through kruskal-wallis test ?

I have to analyze some experimental data of my research work through Kruskal-wallis test. please anyone can suggest me the process of analyzing in Microsoft Excel.

17 August 2020 7,521 2 View

Badges
Science topic