# math using excel

posted by stew

how do i use excel to plot a graph then find x from the slope of a line? y=mx+b. I want to find X:
X=y-b/m. How do i do this using excel?

1. stew

I am trying to find x, which is the protein in mg. I know why will represent absorption. What will i put for m and b for my values? I know one axis is y for absorbance, i don't know what other values to put in for the rest of the graph.

2. DrBob222

I have never done this; however, I went to my Excel program, clicked on the question mark in the tool bar(help but not help at the top of the page written as help) and typed "plot data" without the quotation marks. There are a number of choices but one I chose was "Create XY and line charts." The instructions sounded like directions for plotting data. Others listed may be more what you are seeking. I hope this helps.

## Similar Questions

1. ### managerial economics

my cubic equation is O=C+aL+bL^2+cL3 how can i get the excel to help me to do this equation.I need to do a regression analysis to estimate the firm's short-run production function. see tarha question dated july 2,2007 for all of the …
2. ### math

How do I graph a scatter plot in Microsoft Excel 2003 and find the trend line. I forgot how to do it.
3. ### Data Analysis

You are a District sales manager and you are overloaded with data that you need to compile into useable data and you are looking to use Excel to help you do this. Using the concept from this week, how will you determine where to start …
4. ### economic

I HAVE AN ASSIGNMENT WHERE I HAVE TO PLOT POINTS ON A GRAPH IN EXCEL, THE INFORMATION GIVEN IS QS=2P-20 AND QD=80-2P AND I WAS TOLD TO USE PRICES 10,20,30,40,50 AND QUANTITIES 5,10,15,20,25,30,35,40 FOR THE GRAPH. I HAVE NO CLUE WHAT …
5. ### math 221

1. Using Excel, find the z-score that corresponds to the following Confidence Levels: a. 80% b. 85% c. 92% d. 97% 2. Using Excel, find the t-score that corresponds to the following Confidence Levels and Sample Sizes: a. 95% with n …
6. ### Excel, Access, Word

When you link a worksheet and a chart in a business report as well as on a slide, which Microsoft Office applications are integrated?
7. ### chemistry

i am doing a graph for my chemistry class, and i need help with excel. How do i plot 3.50X10^-3 into excel?
8. ### Physics

I solved the following question: "A ball is launched from the top of a 320 m high building at 50 m/s at an angle of 37 degrees to the horizontal. For the first 10 seconds of flight, make a table of the vertical position from the ground …
9. ### engineering physihcs

I need to create an Excel chart showing world oil reserves vs. time, which are both in columns and cannot find how to graph this in excel. thank you.
10. ### MS Office Suite

I am familiar with Excel 2007. I just got the news that I will be expected to use Excel 2010 instead. What are some of the differences between Excel 2007 and 2010?

More Similar Questions