Excel Scatter Plot | How to calculate unknown value in graph | How to plot unknown in excel graph

  Рет қаралды 81,079

qASh education

qASh education

Күн бұрын

Пікірлер: 39
@vihangitanya2246
@vihangitanya2246 5 ай бұрын
It was really helpful and what I was looking for. Thank you so much.
@nicolevarghese6068
@nicolevarghese6068 3 жыл бұрын
This was extremely helpful, thank you so much!
@odayhujair733
@odayhujair733 2 жыл бұрын
That was so helpful and straight to the point! Thank you for the video! :)
@arzbtbty
@arzbtbty 7 ай бұрын
This is such an amazing tutorial thank you so much!!
@panieladusepoku2333
@panieladusepoku2333 6 ай бұрын
Thank you❤❤❤❤❤❤ it is very helpful
@asmamada209
@asmamada209 2 жыл бұрын
You saved me from a breakdown thank you
2 жыл бұрын
Just what I’m looking for, thank you!
@mrunalinipatil8865
@mrunalinipatil8865 3 ай бұрын
Thank you for your reply 😊
@mrunalinipatil8865
@mrunalinipatil8865 4 ай бұрын
I have tried drawing graph, but on my excel sheet I do not found chart elements ,plus sign So could not draw line and trend line What to do? Please help 🙏
@qASheducationcontent
@qASheducationcontent 4 ай бұрын
I guess this must be an issue of different excel versions. What you can do is right click on the chart, and then select format chart. On the right hand side of screen, you will see a panel open, which will allow you to check the trendline option. Try it out. Lemme know. Keep following
@basilfuad1395
@basilfuad1395 8 ай бұрын
Thank youuuuuuuu❤️❤️❤️❤️
@tefaraashakera6207
@tefaraashakera6207 2 жыл бұрын
very helpful Thank you
@wassupbeauty7331
@wassupbeauty7331 2 жыл бұрын
Hi If possible kindly advise on the below issue: I want to put grade in Y axis instead of numbers. My grades are excellent, good and satisfactory, where excellent means 3, good means 2 and satisfactory means 1. I want to make a chart to show an employee’s progress of five years, like an employee got good in 1st year and excellent in third year and so on. Will this be possible? It would be a great help. Thanks in advance.
@qASheducationcontent
@qASheducationcontent 2 жыл бұрын
Hi, Sure you can do that. But then there's no need to follow this process because you'll already know employee performance. Simply, put your employee name, performance score and year. And plot a column or bar graph. Done. You can also email me at biowriter11@gmail.com for writing services.
@savavgecabbage9442
@savavgecabbage9442 2 жыл бұрын
Amazing, this helped so much!
@anjalithelwadana2575
@anjalithelwadana2575 2 жыл бұрын
Thank you.It was so helpful
@prettyangel2530
@prettyangel2530 2 жыл бұрын
Thank you so so much. This video is so Helpful♥️
@deltabeta5527
@deltabeta5527 10 ай бұрын
Is there any way to extrapolate a vertical line intercepting the x-axis from the unknown point?
@qASheducationcontent
@qASheducationcontent 10 ай бұрын
I don't think there is such a procedure. But you can manually edit and draw a line. And then show the calculated value on the graph.
@deltabeta5527
@deltabeta5527 10 ай бұрын
@@qASheducationcontent At first I did it manually but later I found the way.
@danishdev2068
@danishdev2068 4 жыл бұрын
Hy, thnks alot. U really helped me out. God bless u
@qASheducationcontent
@qASheducationcontent 4 жыл бұрын
It's a pleasure and delight!!😍 Let me know in the comments if you need anything else.
@chamaradias1147
@chamaradias1147 Жыл бұрын
I feel like the answer it gives is always the linear trend line, how about if i wanted to find out the exponential trend line?
@qASheducationcontent
@qASheducationcontent Жыл бұрын
Hello Chamara, It gives the linear trend line because we have clicked on the liner trend line option (which is also the default choice). For an exponential graph, you may choose the exponential trendline. All the best
@fatimakhan5154
@fatimakhan5154 3 жыл бұрын
It was helpful. Thanks.
@shadesofbjork
@shadesofbjork 2 жыл бұрын
THANK U QUEEN
@muhammadsajjad8555
@muhammadsajjad8555 3 жыл бұрын
thanks for handy skill. how will you find unknown absorbance for a given known concentration through formula plz.
@qASheducationcontent
@qASheducationcontent 3 жыл бұрын
Hey, the absorbance of an unknown solution is usually determined on photometer. So you don't have to calculate it separately. If you still want to use it as a formula in excel, simply interchange the X and Y axis.
@cloudyb8155
@cloudyb8155 3 жыл бұрын
thanks for the help! :)
@joshdoz9234
@joshdoz9234 3 жыл бұрын
This was very helpful, thank you :)
@henryhollamby2312
@henryhollamby2312 2 жыл бұрын
Can you do this with multiple points at once?
@qASheducationcontent
@qASheducationcontent 2 жыл бұрын
Yes you can
@dineshjoshi8238
@dineshjoshi8238 9 ай бұрын
How? Plz reply me
@Esther_2365
@Esther_2365 3 жыл бұрын
Hey can you help me with a similar graph problem
@qASheducationcontent
@qASheducationcontent 3 жыл бұрын
Sure. Drop us an email
@muneerhussaindar
@muneerhussaindar 2 жыл бұрын
Thanks
@sasyaffahirah623
@sasyaffahirah623 2 жыл бұрын
What about we know ys value but dont know xs value?
@ashutoshiet
@ashutoshiet Жыл бұрын
The trendline command is not working and giving absurd value.
@qASheducationcontent
@qASheducationcontent Жыл бұрын
Hi Ashutosh, be careful while selecting the X and Y values in the trend formula. If you see my video, I have entered my X values in Y of the formula and vice versa. Give it another try. It should work in all formats of excel too. Let me know if you still need help
REAL 3D brush can draw grass Life Hack #shorts #lifehacks
00:42
MrMaximus
Рет қаралды 11 МЛН
Сюрприз для Златы на день рождения
00:10
Victoria Portfolio
Рет қаралды 2,4 МЛН
Human vs Jet Engine
00:19
MrBeast
Рет қаралды 113 МЛН
Making a scatter graph and line of best fit in Excel
3:35
Dr. Stephen G. Prilliman
Рет қаралды 87 М.
How to Make a Line Graph in Excel - From Simple to Scientific
9:04
Teacher's Tech
Рет қаралды 706 М.
How to make a scientific graph in Excel
7:09
Doug McNally
Рет қаралды 141 М.
Master the IF Formula in Excel (Beginner to Pro)
11:16
Kenji Explains
Рет қаралды 496 М.
Making and Using a Standard Curve in Excel
9:17
Wofford Biology
Рет қаралды 57 М.
REAL 3D brush can draw grass Life Hack #shorts #lifehacks
00:42
MrMaximus
Рет қаралды 11 МЛН