Excel Definition and 335 Threads

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...

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

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...

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...

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

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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.

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...

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...

Mod note: The OP has found an answer to his question.[/color] 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...

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...

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.

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...

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...

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...

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...

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?

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...

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...

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).

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.

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...

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...

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...

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...

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...

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...

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

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...

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...

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...

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...

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...

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...

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 | | \...

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...

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...

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...

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...

Hello, I am trying to control CST from Excel VBA. For instance, I would like to create a routine in Excel VBA similar to the postprocessing template “Evaluate Field in arbitrary coordinates” into Excel VBA, i.e. get the e-field values into an array and insert them on an excel sheet. I read...