Excel Definition and 335 Threads

Hi , I want to create a simple series which give me the following: 0 1 2 3 4 5 . . . from the cells. Please can some help me with it? what I really doing is: I have a set of numbers which represent voltages (of a nodes) inside a dielectric. say: 0.854 0.756 0.659...

I have to program the range formula R= [Vo2sin(2*theta)]/g, into an Excel spredsheet. I need to progran the equation for various values of 'theta' to determine for which value(s) of 'thet' is the range maximum. Table should have left side Injection angle (degrees), right side Range (R). The...

I have a graph of values, and I am trying to add an exponential trendline, but it won't allow me. Can anybody help?

Hello, i am having trouble with working out what the population mean is. Is there a formula in Microsoft Excel to workout the population mean. I have a population of 200

=IF (C1>1,"yes","No") I think that's right :rolleyes: Does Demorgan Theorem use a simular logic when doing calculations for logic gates, using true and false properities?

Hello everyone, I need help with converting or changing degrees to radians in Microsoft Excel. Currently I'm writing SIN and COS functions but the default angles are in degrees, not radians. How do I format it to radians?

My excel does not allow me to change the spacings of the x-axis as it is shaded in gray. What should I do so I can change it?

hey y'all I need help putting passwords on documents, i.e. these documents CANNOT be opened unless the password is provided. This could also be for a folder. Like I have documents in a folder, and I do not want anyone else to have access to this folder, I would therefore like to password...

Is there any way to make a referance to a cell that contains a number for another referance? Like this. cell A1 contains "J". I want cell B6 = J10 by referance of A1. I'm trying to make a spreadsheet that makes a list into flash cards BTW...if anyone knows a 3rd party program (for free) that...

every subect seem to be different! which kind of graph and a lot what axis do i plot, if i was to do plot resolution against lux! plus anyone kno the proper way to do this in excell. thanks

How do I change the scale of the x-axis so that it does not automatically plot the number of data I graph but my customised x points? My situation: I like to graph hundreds of different points or data But only want the x-axis to be from 0 to 3, including decimals in between.

I need to get a Word table of postal addresses into an Excel spreadsheet. I want to preserve the line breaks in the original addresses. Is it possible to have line breaks within a single cell in Excel? From Word table: [FONT="Courier New"] ...Col 1...Col2 R1: Bob Smith...21 Foo...

I am trying to do a scatter plot in Excel, and I am referencing points from a different sheet. However, excel won't let me reference more than eight cells. Some of the cells are merged, I don't know if that will affect it... Any help would be appreciated.

I'm trying to save an Excel spreadsheet as a (tab-delimited) text file for input into another database. For some reason, fields containing a comma are being displayed in the text file within quotes, which I don't want. For example: John Doe appears as: John Doe Doe, John appears as: "Doe...

I'm trying to use the solver in Excel to solve a set of two equations, but I can't figure out how it works. Can someone give me a step by step description?

If you are in need of an analysis tool and/or homework aid, you may not realize that you probably already have an extremely powerful general purpose tool at your disposal - Microsoft Excel. I don't work for Microsoft nor am I even much of a fan of theirs, but I've found it an extremely...

Hi I'm currently working on an assignment and one of the questions requires me make a plot of the following. I am told that Excel can produce the plot but I don't know how to enter the equation. x_{n + 1} = \frac{{11.5x_n }}{{1 + x_n ^2 }} - \lambda ,x_0 > 0 A few values of lambda...

Hi , I have to generate a function on excel that does the following the problem is about polynomial interpolation. I have for example a column of values: -100 0 100 200 300 400 First , I need to find the value in the table that is 2 point above the input value. For example , if...

Maybe not the best place to ask the question, but being an engineer, I figured that I might be able to pick someone elses brain about this matter. I have one column with a Time value in hh:mm:ss. There are multiple other columns that I would like to graph as well...up to 15. Rather...

helo, just wondering if anyone could tell me how to solve a fourth order polynomial in excel. i have a fourth order polynomial of form y=F(x), but i want it to be x=F(y)

Describe the process of simulating a brownian motion with drift of 4 units and diffusion of 2 units. write a program in any application to imulate such a brownian motion. Anyone knows where should i start first if i use excel to do it. I don't know what equation to use.

I want to include an excel table in a Latex document. How could I do that? I have tried to print the table to a file .eps, but that does not give me a good result. Is there another way?

I performed a fit, using EXCEL, to data and the fit gave me a polynomial. How do I get the uncertainty in the resulting parameters. For example the least squares fit gives y = Ax+B and there are equations to give the uncertainties in A and B. IS there a program that does this for non linear...

I need to plug some equations into Excel. I am using the Insert-->Name-->Define feature to assign a given cell to a defined named variable. Example... cell a1 = X, cell b1 =y this way I can say cell c1 = X*Y rather than having to say c1=a1*b1 Here's the problem... I need to...

For my lab i have to use my data that i recorded in excel and for that into a chart. The thing is, i have no clue where to even start. The chart is supposed to have the avg at the top of the curve and the standard deviations to the left and right of the avg. On the Y-axis is supposed to be the...

Hopefully somebody here can clue me into figuring out a math problem. I'd like to create an Excel spreadsheet that will allow me to enter my numbers and have it calculate the results, but I'm not sure how to do the calculation (or for that matter, perhaps how to enter it into Excel...) So...

I'm need to use Microsoft Excel as a numerical analysis tool for classical mechanics physics problems. Yes, I know there are dozens or hundreds of other tools that would be more powerful, but I (and my students) are required to see what they can do with Excel. The Class: Analytical...

I am having some problems with equations for a problem. The problem isn't really a question, it's more of finding equations to make something work. Basically, It is a graph on Microsoft Excel, that resembles a 2D track. The track has variable points that you can change, to increase height...

Need help on radial distribution on excel! I'm trying to create an excel spreadsheet that plots radial distribution functions for the 3s orbital of hydrogen for values of p=0...15 I have no idea where to begin

Is it possible to input a function into Excel e.g. 1/(x^2+4) and get a graph? How do you draw graphs of functions on Excel?

I have a problem in statics that I must use excel to do and my instructor modified the given question in a few ways to allows to use the capabilities of excel to find what the question asks for. http://herograw.com/5-51.JPG These are my instructors additions: If the whole excel...

:confused: I have plotted a few points (8 infact ) in Excel and would like to acquire the equation for the line of best fit. How do I do this using the computer or do I have to do it by hand?

I have to do this problem using Microsoft Excel. A motorboat leaves the dock and travels in a direction 15 degrees East of North for 20 minutes at a constant speed of 20 miles/hour. At that point the boat abruptly changes its direction to 20 degrees South of West and its speed to 25...

I'm trying to create error bars on excel for a regression problem, but something is not working right. I tried following my instructor's directions, but I think something is wrong with them. Here is the formula I added to the formula bar: $b$30+$b$31*$a2+sqrt($d$26) b30 and b31 are my...

I wasn't really sure what forum this belonged in, but I'm doing an equation with Microsoft Excel, using Factorials. Basically, I'm wondering how you go about using them in an equation. Here's my current equation: =A5!/(A5-B5)!B5! Now obviously that comes back as an error. Does anyone have...