Excel - AVERAGE Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

A 555-mile, 5-hour plane trip was flown at two speeds. For the first part of the trip, the average speed was 105 mph. Then the tailwind picked up, and the remainder of the trip was flown at an average speed of 115 mph. For how long did the plane fly at each speed?
Solved by F. F. in 7 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
User 17/07/2017 - 05:09
Not off hand.
Excelchat Expert 17/07/2017 - 05:09
Do you have a excel file?
User 17/07/2017 - 05:09
I don't. I just need help with this problme
Excelchat Expert 17/07/2017 - 05:10
I'll help
User 17/07/2017 - 05:10
User 17/07/2017 - 05:10
Where do I start?
Excelchat Expert 17/07/2017 - 05:10
BUt please note this isn't a fixing formula category problem
Excelchat Expert 17/07/2017 - 05:10
so going forward don't post it that way
Excelchat Expert 17/07/2017 - 05:10
I am going to perform the following:
Excelchat Expert 17/07/2017 - 05:11
Excel sheet with formula to solve the problem
User 17/07/2017 - 05:11
okay ... I'm sorry
Excelchat Expert 17/07/2017 - 05:13
Excelchat Expert 17/07/2017 - 05:14
2 hours at 105
Excelchat Expert 17/07/2017 - 05:14
3 hours at 115mph
Excelchat Expert 17/07/2017 - 05:14
Attached is Excel
[Uploaded an Excel file]
User 17/07/2017 - 05:15
Thank you!
Excelchat Expert 17/07/2017 - 05:15
I’ve completed the solution, take a look if you would like. We can now continue to the discussion stage and I can answer any questions you may have with the solution I provided.
User 17/07/2017 - 05:16
I think I got it! Thanks!
Excelchat Expert 17/07/2017 - 05:16
If not, Please close the session and share your rating
Excelchat Expert 17/07/2017 - 05:16
Have a nice day!
User 17/07/2017 - 05:16
you too!
Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc