Excel Definition and 335 Threads

Is anyone familiar enough with excel to use it to find the sum in of sigma notation when "n" is large? \Sigma^{40}_{k=1} \sqrt\frac{3k-3}{4} Something like this?

Hello everyone, Over the past year, I have been trying to simulate the launch of a rocket to orbit using excel. I have been pretty successful, and I have what I think to be a mostly working product. However, it has some problems that may be affecting the results. First, I'l explain roughly...

Can you fit data that is imported into Mathematica 8? I am just using the Import command, and I cannot figure out how to work with this data. I would really like to fit my curve. This is the code I used to import the data: Import[datafile.xlsx"]

On the internet there is only information on how to get rid of the trianglethat indicates an error in the formula in the cell. But in my workplace I need to upload data to a program and sometimes a successful upload requires that the data in my excel cells be marked by this error-triangle...

Autocorrelation function in Excel (SOLVED) Hi, I have tried reading through this forum looking for similar example but am unable to find one. Basically, I have a large set of data that I intend to do autocorrelation. =CORREL(A1:A10000,A2:A10001) =CORREL(A1:A10000,A3:A10002)...

Homework Statement I had to make a Linear Least Squares Excel template for my first week's Physics lab to analyze linear data for the rest of the semester. All of my values come out correctly, except the standard deviation values. I was wondering if someone could take a look at my template and...

I really need your help - i can't work out how to do a FFT in excel. The main problem is I don't have a constant sampling rate - I recorded the time and then the corresponding magnitude of the wave. I have followed everything oneline but I can't seem to get anything to work as I can't fill the...

Hi guys, I have to find the deviation from the mean for each individual entry of a column of numbers. Any one have any idea how to do this? I'm clueless when it comes to excel

I figured there ought to be some Excel savvy people here. Anyway I can't seem to get the LINEST function in Excel to return anything other than slope. I provide it with y-values, x-values, and say true to constant and stats. All it gives me back is a slope. Maybe I'm being vague, just ask if you...

Different correlation coefficient results between Matlab and Excel. Please Help! I have two sets of dat as below. A problem is that MATLAB and excel returns a different value of correlation coefficient (i.e., 0.801 from Excel and 0.786 from Matlab). For Matlab, I used the function...

Hello all. I am trying to get my code to color cells if a referenced cell is populated. That part works but when I tried to populate another cell a different color I encountered a problem. You can see where the mistake comes in on the code. It is when I try to populate a variable 'strMyVar'...

Can Excel plot graph? If not, is there any free software to plot tables of numbers from Excel to XY graph.( just common graph)?

Homework Statement using the table of values supplied (a pdf document), construct an excel spreadsheet wherein a value can be input from 200-2250 and output will be air's specific heat capacity at that temperature. Homework Equations Cp= H2-H1/T2-T1 The Attempt at a Solution I...

Background: I am working with pump curves in a hydraulic model. The model is written on excel. In the model pump curves are defined using tested flows vs. dynamic head (ft). The problem I am having is an iterative solution to fit an equation to the data points. Once the first equation is fit...

I was watching this YT film about plotting on Excel. I copied the numbers from the film into an Excel sheet and plotted x against y1 and got a blue coloured plot. Then I plotted x against y2 and plotted a chart again. Though a second red coloured plot did not appear as in the film...

Hello, I am attempting to take data from a PDV laser reflected off a vibrating surface and then convert that data into a sound file. The data from the laser is stored in an excel spread sheet but I do not know how to convert those data points into any form of sound file. I'm thinking a .wav...

Hi, My name is Stuart and I am an undergraduate student at the University of Strathclyde, UK. I'm just about to start my 3rd year but I was lucky enough to successfully set up a summer project for during the summer where I am working in the Centre for Biophotonics. I've been a member here...

Hi, I'm currently working on a project that requires me to convert a Fortran code into excel vba. There are some problems that I've stumbled into, so itll be great if someone could help out. one of it would be on how to convert a COMMON statement in Fortran to Excel VBA ( as in how would...

Is it possible to draw histograms in Microsoft Excel? I see all charts of icons in the Excel tool bar but no histogram.

Hi there, I am trying to make a spreadsheet which calculates the heat loss through a pipe and also heat loss when insulated, I am using the resistive analogy to calculate this and I have it working, the only problem I am having is the heat transfer coefficient, how do I calculate this? I...

I have a table of numbers say 12 X 12 i.e A1 cell to L12 cell. All of them have numbers filled in. I have to create another table of identical size. first row and first column numbers are just duplicated in the new table i.e.A1 to A12 (first column) A1 to L1 (first row) cells are just...

I've discovered that MATLAB is not my forte. I have a 51x3 matrix that I want to print to an Excel sheet, but with column headers. I can get the matrix into an Excel file and I can get the headers into an Excel file, but I cannot figure out how to get the two together. I've looked up how to do...

Homework Statement I have a thousand random numbers generated between -100 and 100 and want to count the number of occurences of each integer. I know i can use the COUNTIF function, but for so many numbers it takes way too long. Is there a way to create a loop in excel that can do this or...

Homework Statement I have two columns of data to graph from a lab we did on spherical lenses. The instructor showed a quick and dirty sketch of what our graph should look like - a decreasing curve. My data plots as an increasing linear graph. If I flip the x-axis data top to bottom I can...

So, I need to make an Excel spreadsheet that realistically models the motion of a toy rocket. I need to take drag, gravity, and thrust into account, keeping in mind that the latter two will be influenced by the change in mass. The equation for force I must use, then, is: F = ma + v(dm/dt)...

Dear all, I am currently using excel to work out some values for incident solar radiation but I am running into a rather frustrating problem when I try to do the following: =COS(9.863) my calculator tells me correctly this is 0.985. however, when I put this in excel it decides it...

How would I go about creating a line of worst fit in excel? Would I create a different row for the uncertainties?

Hello everybody, I have a fortran.exe (compiled using intel visual fortan comipler 10.1.24 and VS 2005) which takes an input.dat file and generates output.dat. Currently, I am trying to control fortran.exe execution with excel 2010 shell function. But it is not working properly. The...

I want to use Excel to figure out how much money, in dividends, I could make if I bought a stock in Microsoft, whose stock has recently stayed at $30-$31. They pay $0.80 in dividends/share. So far, I have a spreadsheet with columns "Years," "Shares," "Share Cost - Dividends," and...

I have all the information I need, but I just need a bit of help on getting my data on a normalized histogram in excel. First, if I'm not mistaking, a normalized histogram is just a normal histogram where it is roughly symmetrical about the curves centerline, is that correct? I have a list...

Hi, I know that Standard Error of a coefficient is the standard deviation of the sampling distribution associated with the coefficient. I understand the concept. What puzzles me is this: We have just one random sample to work with. The calculator or Excel doesn’t have any info on the...

Attached is a problem that I am supposed to use excel to find the best estimates of a and b. As I am horrible at excel could someone give me some pointers or an idea how to start? Please don't do it for me, I want to learn how to do it - I just need some help.

Excel VBA change (or "edit") links Macro I have a Excel spreadsheet that has several links in it which I need to change to a different computer/user. The links are all the same and to change the source I have to go to "Edit Links" and manually change the location to the specific location on my...

I have an csv file that has a column of numbers in the form ab:cd:ef:ghy The cell's number format is general, I want to be able (if other criteria are met) to change y into y+1. The final column must again have the form ab:cd:ef:ghy and the number format general, can anyone out there give me an...

I'm having a problem with a Physics / Excel sheet I've been working on. Does anyone here think they might have the Excel expertise to help? It's not very advanced Excel. Get in touch immediately please if you do. Thanks

Homework Statement Homework Equations v(t) = v0*e^(-t/RC) i(t) = C*(dv/dt) E = .5*C*V^2 P=v*i The Attempt at a Solution I'm having trouble with part e. As far as I can tell, all of my equations are correct, but the total energy delivered is notably less than the initial energy; I was hoping...

Ok, this one exercise is really getting to me. Either I missed something, or our prof hasn't gone over any of this. I was hoping someone could decode this for me. Question: ____________________________________________________________________________...

This is part of the simulation program in Antenna field pattern. One part involve finding the position of the peak where: AF=\frac {\sin\;Nx}{sin \;x}\;\hbox { where N is an integer.} The peak is at x=0 and the AF=N. But excel do not accept this and call out as "DIV 0" error. Is there any way...

I have a set of 9,999 equi-spaced data points, and I would like to calculate the autocorrelations for ALL lags up to 5,000. In Excel, I want to have this code: =CORREL(B1:B9998,B2:B9999) =CORREL(B1:B9997,B3:B9999) =CORREL(B1:B9996,B4:B9999) ... =CORREL(B1:B5000,B5000:B9999)...

Need to find optimal solution by solving 2 equations X= VR*(R2+R1)/R2 - VN*R1/R2 Y= VR*(R2+R1)/R2 - VP*R1/R2 VP, VN are fixed. VP=5 & VN=0 VR can change. R1,R2 should be same. How do I find a combo of VR, R1, R2 so that - X = 0.46 & Y = 0.214 (this part is easy) The same...

Hi...i have question on RLC circuit. Why my max.voltage of complex sinewave in Excel is different from the simulated complex waveform? which one is right? max.voltage of complex waveform in excel = 106.8V max.voltage of complex waveform in simulation = 126.8V Should it be the same?

Hey Everyone! I'm looking for a good tool to do some high performance computing and analysis for my research. I've been going back and forth about using Excel as my primary tool as it is pretty straight forward so that I can share my data and results with others. Does anyone have any thought...

Homework Statement This is the third problem of a project for a Calculus II course. My issue is with graphing. Below is the problem, and below that my tutors explanation via e-mail to try and help me. I understand everything thus far, except for how I go about graphing. I am not strong in...

Hello Does anyone know if it's possible to run an excel file in Simulink? I have a column with a variable in excel, and don´t know if there is a block that I can get in simulink to run this variable. Regards

I have some data and i want to plot them on excel. I am trying to plot them but i am drilling a hole in the water. I will appreciate if anyone can help me with this. I want 3y axes and 1x.Thank you.

Using Excel 2003, I'd like to display text data in the Data Items area of a pivot table. Currently, I see the number 1 in the field. I've changed the format to "Text", which has no effect on the data that's displayed. Is it possible to display text data in the Data Item area of a pivot table...

Hey all, I'm looking for a version of steam/water thermodynamic properties for excel. I need it to be able to compute properties based on pressure and entropy. Something similar to the X Steam Tables (http://www.x-eng.com/XSteam_Excel.htm) would be awesome, but again, I need the ability to...

I can't get this formula to come out. I have done it on excel step by step over and over and it gets close, but always a little under. As in if the chord angle is 45 and I do all the calculations on the other side, it calculates to 43.85. They should both be 45 so I don't know what is going...

Homework Statement I have to calculate g or find the acceleration of g using the slope of the trend line from the y vs. t^2 graph. I had to use excel and did this for lab with data and use the equation excel came up with after i finished the graph, and I have no idea how to find the...

I forgot long time ago the little I knew of VB applied to Excel. Can anyone give a snippet of VB code to get the value in cell C8 to increasing by n every time I click the mouse on cell C9? I recall that being possible but I am clueless now. Gracias for any help.