What is Excel: Definition and 346 Discussions

Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android and iOS. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications (VBA). It has been a very widely applied spreadsheet for these platforms, especially since version 5 in 1993, and it has replaced Lotus 1-2-3 as the industry standard for spreadsheets. Excel forms part of the Microsoft Office suite of software.

View More On Wikipedia.org
Recent contents Top users
  1. A

    Excel trend line vs regression analysis

    I did some data analysis with excel fitting some linear, zero intercept data with trend line and the regression analysis tool. The slopes generated by the two methods were different by about 10%. The regression line seemed to be weighted differently, are these two methods different for some...
  2. henil

    Plotting Graphs in Excel | Functions of x and y

    Mod note:Combined two posts into one. 1. Homework Statement f(g,h) such that g is a function of x and h is a function of y then how can i plot a graph in exccel Homework EquationsThe Attempt at a Solution
  3. L

    Excel - linest function with blanks help

    Hi, Ive been trying to use the linest function with blanks but I can't get it to work... (specifically =INDEX(LINEST(E6:E16,A6:A16^{1,2,3}),1). Here A6:A16 is a number increasing in increments of 1 between 25 to 35, and E6:E16 is only filled if the corresponding measurment is made. Does anyone...
  4. T

    How to Plot Constant Temperature and Pressure Lines in Excel for Thermodynamics?

    Homework Statement Hello, My thermodynamics professor gave us homework to plot 3 lines of constant temperature on a PV diagram in excel and 3 lines of constant pressure on a TV diagram. I have no clue how to do this and was wondering if someone could help me Homework Equations He gave us the...
  5. P

    Excel vba button to clear numeric content

    I want to clear numeric content(without clear others) in certain range with a button. example: $E$10:$H$26 and $K$11:$Z$15. What macro code should I have? Appreciate your help
  6. E

    Adding Exponential Trendline to Graphs: Struggling

    Hi, I need help to add an exponential trendline on my graph. I have three graphs and I have succeeded with the first one but somehow the exponential trendline will not show on the two other graphs even though I have selected the option multiple times. I also tried to re-do the graph in a new...
  7. Matt atkinson

    Excel Simulation help - Electron runaway with given frictional force (Bethe)

    Homework Statement I'm trying to create a simple excel simulation for runaway electrons using a given energy-loss per unit distance equation (Bethe formula). I'm stepping through time (pico-seconds) and giving the the electric field some initial value at a distance of 1mm and from there...
  8. beyondlight

    Designing a Carry Lookahead adder in Excel sheet

    I'm designing a carry lookahead 8bit adder. My problem is that i don't know how to calculate the group generate signal. I have 4 G signals: First level: G1:0 G3:2 G5:4 G7:6 And these have to be added together: Second level: G3:0 G7:4 Third level: G7:0 Two different formulas for computing...
  9. L

    Excel's Power trendline formula?

    Can you please tell me what MS Excel uses to find a Power trendline? I have been experiment with data from my PunchBot project and it seems the Power Trendline fits the best. The plan is the used the data from my machine (an array of time intervals) to find the curve of the acceleration and...
  10. Y

    What Could Be Causing Excel to Stop Functioning on My Computer?

    I have a ligid MS Office 2003 with excel. I have this loaded on my newer computer and had been working until a few days ago. All of a sudden, I cannot change what I typed in the file anymore. I restarted the computer, I uninstalled the Office 2003, then reinstalled the whole thing again. It...
  11. M

    MHB How to workout the exponential curve using x and y values and without excel

    Hi All, I have searched for hours but cannot figure this out. I need to find the equation for an exponential curve but I only have the x and y values. Is there a way to do this without using excel? I tried to follow this on YouTube: https://www.youtube.com/watch?v=ta4MZS7w2VA but the equation...
  12. BiGyElLoWhAt

    Simulating Sawtooth Wave in Excel: Tips & Tricks

    I hope this is the right place for this question. I had to do a Fourier series for a sawtooth wave f(t) = t from 0-1 and simulate it in excel, and put it through a low pass filter, also done in excel. I've been having problems with the filter, but that's beside the point. I have the...
  13. T

    Calculating Thermo Properties of Water in Excel

    Hi - I am currently working on a paper verifying some thermal hydraulic code against experimental test data for subcooled water subchannel flow. I have close to 1000 points in excel all listed with T & P and the process for inputting the corresponding enthalpies for subcooled water by lookup...
  14. T

    Multiple Regression in Excel for Mac

    Hi, I was wondering if anyone familiar with excel on a mac can help me? Am i able to do polynomial regression with different x's who contain different amounts of elements? I have three columns, one contains 252 elements, another contains 53, and the last contains 12. They are all closing...
  15. C

    How to excel at a Master's Degree

    Hi Guys, Please give me some advice! Kindly bear with me while I explain my situation. I'm incapable of explaining things briefly :( I'm 24 year old with a dual bachelor's degree (Physics + Mechanical Engineering Design). I graduated in Aug 2012 and immediately started working as a Design...
  16. steves1080

    Identifying Outliers in MS Excel: How to Create a Formula for Numerical Ranges

    I have a row of numbers, and I want to create a formula that will look at the entire row, and then look at ONLY the filled-in cells (i.e. ignore blank cells), and then determine if any of the values in that row are inside a specific numerical range. If they are, great. If not, I will make a...
  17. M

    How to Format a Table in Excel 2010?

    Hi, all. I use excel 2010 and when I click on Format as Table there is no " Format as table diaglogbox" which asks "where is the data for your table" but rather discontinous lines under the names light,medium, and dark.
  18. C

    Linear Regression Error on Excel

    This is for an experimental physics homework,I am using the latest version of MS Excel. I have a set of data, I perform linear regression on them and it gives me a line y=ax + b. Given that both a and b have physical significance I would like to know how could I know the uncertainty...
  19. J

    MATLAB Export Standardized Matlab Data Points To Excel

    Dear Experts! I currently have a sets of data with different time interval and I plotted it into MATLAB from excel. Is there a way for me export the files or calculate the mean, standard deviation etc so that I can calculate error etc. It would be great if I could do it in Matlab. I am...
  20. iamjon.smith

    Comp Sci Getting VALID range of Excel Cells in javascript

    Mod note: The OP has found an answer to his question. I am validating a text field in javascript in EXTJS 4 framework, based on the selected value of a text box: else if (record.get("type") === "CELL_VALUE" && record.get("apply_before") === true) { Ext.Msg.alert("Field Validation"...
  21. D

    Standard Additions plotting in excel

    Homework Statement I have a set of values from a laboratory work (standard Additions practical), which I am required to plot. I am finding difficulties in plotting the values in excel because the horizontal axis must have some negative integers. Homework Equations The Attempt at a...
  22. Z

    How to Calculate the Brackett Series in Excel?

    Homework Statement I want to produce a simple Excel sheet to calculate the wavelengths of H atom transitions and calculate, in nm, the first 4 lines of the Brackett series. Homework Equations The Attempt at a Solution Attempt at Excel sheet attached.
  23. M

    How to get the equation of the plotted curve in Excel?

    How can I get the equation of the plotted curve (see attachment) without using the trend line? I've already fitted the random red points using the log-Pearson Type III Distribution (and the result is the blue curve) so I don't need to fit them anymore using any trend lines available in excel...
  24. BiGyElLoWhAt

    Wasn't sure where to put this - Lowpass Filter in Excel

    Wasn't sure where to put this -- Lowpass Filter in Excel Ok I need some excel help, I need to model a sawtooth wave mathematically (done) and then I need to put it through a lowpass filter, but I need to do it in excel. My prof expects an excel spreadsheet, and I have no clue how to put it in...
  25. Q

    MATLAB Help reading an Excel file with Matlab

    Hi everyone, this is my first post on the physics forums. I am trying to use the readtable command in Matlab to make a table from an Excel file. Matlab is still new to me so I'm running into problems a lot. When I input T = readtable('myfile.txt'), I get an error that says "? Undefined function...
  26. D

    Is the Dart Throwing Data a Gaussian Distribution?

    Homework Statement We threw a bunch of darts at a dart board to find the statistics of the positions. They ranged from -20 to 20 and the data is right here. ( each column corresponds to the dart number, it is just a syntax thing) The frequencies are below. Dart 1 Dart 2 Dart 3 Dart 4...
  27. S

    Using numbers as markers in excel.

    I'm modelling the Diesel cycle using excel and I'd like to have the 4 different states numbered on my P-v diagram. I can mark these four points using shapes, but I'm not sure how to do it using numbers instead of these markers. Can this be done?
  28. S

    Modelling Diesel Cycle in Excel.

    Homework Statement Construct a Microsoft Excel® spreadsheet that models an internal combustion engine based on the ideal air-standard Diesel cycle. Given the minimum temperature (##T_1##) and pressure (##P_1##) in the cycle, the engine size (##V_1##), the compression ratio (##r_v##), the...
  29. S

    Making Excel Automatically Calculate 2 Out of 4 Values

    So, I'm a creating a spreadsheet which receives a number of inputs from the user and then does various calculations with these values. The user need only input 2 out of the 4 inputs below and as you can see, with 2 values, the other 2 can be calculated. How do I make it so that excel does this...
  30. M

    How Do I Plot a Single Period of a Waveform in Excel?

    Hello. I have this set of data that I have to plot with excel but I only need to plot for ONE PERIOD of the waveform. But how do I determine from what data to what data is one period? In the data, the left side is time (s) and right side is the voltage (V).
  31. S

    LaTeX Adding an excel graph into a LaTeX pdf.

    How do I go about doing this? I'd like the graph to be fitted to the size of the page (A4) also, not just stuck on at the end in full size.
  32. A

    Add Error Bars to Individual Points in Excel 2008 for iOS

    Hi, Okay, I'm in a bit of a rush: Can you put error bars on INDIVIDUAL points in Excel? I found the "custom" setting for the error bars, but you can only add custom error bars for ALL points. I'm looking for a way to mark errors for each point individually. Is there any way to do that? I...
  33. StevieTNZ

    Calculating Huge Numbers in Excel

    Hi there, If I perform the following calculation in Excel: =100,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000+50 I get: 100,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000...
  34. I

    Estimate Probability of Excel Data Analysis Results

    Not sure where to post this question, but here goes In excel I have calculated the average annual rain for the period 1990-2012 to be 50.2mm . How do you estimate the probability that this measured average (1990-2012) is consistent with the long term mean annual rain for the period 1948-2012...
  35. M

    Finding the slope of a section of a graph in excel

    Hello, I have a graph of a tensile test of a metal sample, and I wish to find the slope on the graph of only the elastic region of the graph, meaning of the entire graph, there is only one section of it that I am interested in finding the slope for. Is there a way in excel to make it such...
  36. D

    What is the Probability of Insect Contamination in Multiple Chocolate Bars?

    Homework Statement Data from www.centralhudsonlab.com determined the mean number of insect fragments in 225-gram chocolate bars was 14.4, but three brands had insect contamination more than twice the average. Assume the number of fragments (contaminants) follows a Poisson distribution...
  37. A

    MATLAB Excel date column export into Matlab

    Hi everybody, I need assistance. I have excel file that conntains a date column and another column. I wish to plot the date on x-axis and the second column on y axis. I wrote the MATLAB code below. This is my code. data=xlsread('DataTest','Sheet1'); q=data(:,2); time=data(:,1); Error...
  38. StevieTNZ

    Random Generator in Excel 2013

    Hi there, In Office Excel 2013 - If I make a list of five statements, each in a separate cell but within the same column, in another cell how can I get Excel to randomly select three of those statements? Not sure how to write the =RAND() equation. Any help will be much appreciated, Stevie
  39. Y

    Excel Macros & VBA | Learn Programming Basics

    Hello all, A brief introduction to my skill set: I've taken an intro to C++ course which was geared toward Science/Math/Engineering students so I'm familiar with programming in general, conditions, loops, functions, pointers (or whatever its called when you call by ref/value etc), arrays (n...
  40. K

    Simple Pendelum - Help with Quadratic Regression on Excel?

    1. I am trying to determine the value of g based on a simple pendulum. I have graphed a scatter plot with the x-axis as L and the y-axis as P. I have 3 different series for different lengths of pendulum. When I try to find a line of best fit I get something like cx^2 + dx + e and this trend...
  41. Z

    MATLAB Using Excel Sheet Values as Variables in MATLAB: How Can I Solve for X?

    Matlab... Please Help! Urgent... Hi mates, how can I use the values from an excel file as variable values in the equation below ? in other words...I need to use a lot of g values listed in an excel sheet and to find the value for x...or I ll import g values to MATLAB from excel and...
  42. P

    Creating a Solar Model - Excel Help

    Homework Statement The problem given is...Calculate mI+1 and lI+1 at point xI+1 using equation (5), the values of the slopes at points xI+1 and xI from equation (4), and the values of mI and lI from the previous step. Here is a screenshot of my solar model Homework Equations The Attempt...
  43. M

    Numerical integration of Bethe formula in Excel: help

    Hello, I am a PhD student in geology in need of help from a physicist! Can somebody spot the mistake in my spreadsheet? I am using an Excel spreadsheet (attached .xls) to integrate the Bethe formula in order to estimate the range (in cm) of alpha particles in quartz. I am using the version of...
  44. C

    Excel Problems with error bars

    I have a graph which I would like to add Y error bars to. When I click to add the error bars, it only allows me to add horizontal bars. This is very strange because the other graph I have, it allowed me to insert vertical bars. Basically when I click on exactly the same menu to insert error...
  45. B

    Modeling oscilations in Excel

    Homework Statement You have a car going over a speed bump, you need to model the oscillation of the car using excel only (no MATLAB or other software) Simple Schematics: |Mass of car| | | Spring Damper | | \...
  46. Y

    Fortran Can Fortran read input data from Excel?

    I have prepared the coordinate of a pipe layout in excel. Now I have to input them into a FORTRAN code. Although I know it is possible to generate these coordinates inside FORTRAN, but working with Excel is much easier for me. Making these coordinate data inside FORTRAN is a very hard work and...
  47. E

    Should i go for power engineering or excel my career in hvac.

    i m going to be a mechanical engineer this year :smile: ,In my third academic year i studied a subject named as steam generation and steam turbine..that subject is awesome ..since i have strong background of thermodynamics i liked it very much and got highest marks.its my final year now..and i m...
  48. M

    VBA Excel Functions for Compressible Flow. Houghton and Brock Tables

    G'day! This is my first post on this forum and I hope you find it usefull! Attached are complete set of Excel functions for *Isentropic Flow *Prandlt Meyer Expansion *Raleigh Flow *Fanno Flow *Plane Normal Shock *Plane Oblique Shock They are contained in the attached workbook (zipped as it...
  49. S

    Can Excel accurately calculate planet positions in real-time?

    Hi All, I wanted to see if it were conceivable to create a spreadsheet you could calculate the position of planets within our solar system given a lat and long position and using the current time? I've tried searching for something similar, or formulas to calculate these, but haven't had...
  50. Z

    Plotting a Difference wave in Excel

    I have plotted two approximately sinusoidal waves in one Excel graph. Both waves are voltage, on the y-axis, against time the x-axis. Though both waves are not identical, being out of sync a little. The first wave has quite a lot more readings which make it than the second wave. If I...
Back
Top