Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need excel sheet of the information given below i am posting this question 4th time so please make it quick sir/madam. Please find the

I need excel sheet of the information given below i am posting this question 4th time so please make it quick sir/madam.

Please find the attached file. Format it in a way that is presentable. Also include the following functions -

Rounding Data Values
oROUNDDOWN
oROUNDUP
Calculating Minimums and Maximums
oThe MIN and MAX functions return the smallest and largest values from a specified set of numbers:
MIN(number1, [number2], )
MAX(number1, [number2], )
Measures of Central Tendency
oMean
oMedian
oMode
image text in transcribed
image text in transcribed
both sir in different statements round up and round down .it is just that i have to show how all the things done in sheet.
Documentation Wait Times TechMasters Author Date Purpose To analyze the wait times of technical support calls to TechMasters Documentation Wait Times TechMasters Technical Support Wait Times sec. Wait Time Measures Excellent Good Acceptable sec. sec. Poor sec. sec. Very Poor Unacceptable sec. Wait Time (Seconds) SUN MON TUE WED THU FRI SAT 12:00:00 AM 16.95761603 28.050964 28.492651 27.702579 25.622203 21.913675 17.188812 1:00:00 AM 17.16171256 32.898919 30.382064 29.519377 30.941405 26.580769 16.31882 2:00:00 AM 17.06693024 37.673798 33.667723 31.938764 27.072914 32.140855 17.186023 3:00:00 AM 19.43984722 41.196339 31.517793 29.670036 26.100667 33.267228 15.708261 4:00:00 AM 23.71719122 43.169752 36.105633 34.496885 31.54592 38.866652 21.379538 5:00:00 AM 24.68240627 48.257581 41.103589 39.509919 37.637852 42.083924 24.460009 6:00:00 AM 27.38303081 51.716832 41.937089 45.046124 40.397449 49.069008 24.756617 7:00:00 AM 34.42322941 64.312891 57.662735 45 266952 43.088519 57.47371 28.823902 8:00:00 AM 42.61331257 78.297056 66.159342 61.451581 57.485592 74.486093 34.818078 9:00:00 AM 48.30205284 88.176918 74.642123 70.57989 66.366118 83.754653 46.460385 10:00:00 AM 37.55534041 79.78442 65.945801 58.637683 53.161458 67.627094 36.076242 11:00:00 AM 42.22735134 80.360576 83.21481 60 203453 56.497115 74.964236 37.873544 12:00:00 PM 50.74941768 96.595129 91.401581 77373798 67.727341 88.945852 43.557561 1:00:00 PM 42.47873777 93.505153 81.297018 64 318223 61.717769 84.428696 39.616744 2:00:00 PM 37.75912042 73.887305 63.410616 57.083038 51.925061 69.108308 34.497314 3:00:00 PM 35.81579895 67.090208 58.384951 54.51821 50.768482 63.399254 33.8685 4:00:00 PM 32.42494065 62.812849 35.437345 46.655233 48.073496 61.722805 28.914685 5:00:00 PM 29.75712658 63.931318 56.214868 51.346236 48.480744 58.910087 28.8004 6:00:00 PM 32.564027 58.222848 51.437686 47.655273 43.773173 55.81668 28.143525 7:00:00 PM 23.20970568 53.285803 46.708265 42 516073 39.99436 47.35441 25.996101 8:00:00 PM 24.70495176 49.328089 39.753369 39.725828 32.881976 32.177311 18.836767 9:00:00 PM 21.97741418 43.617365 40.301784 40.288394 31.683676 30.672514 19.159309 10:00:00 PM 21.57221454 35.041132 34.063196 37.648352 32.211053 23.038875 18.582357 11:00:00 PM 24.66721764 32.779786 31.883353 32.837071 25.973378 19.338525 16.502403 Documentation Wait Times TechMasters Author Date Purpose To analyze the wait times of technical support calls to TechMasters Documentation Wait Times TechMasters Technical Support Wait Times sec. Wait Time Measures Excellent Good Acceptable sec. sec. Poor sec. sec. Very Poor Unacceptable sec. Wait Time (Seconds) SUN MON TUE WED THU FRI SAT 12:00:00 AM 16.95761603 28.050964 28.492651 27.702579 25.622203 21.913675 17.188812 1:00:00 AM 17.16171256 32.898919 30.382064 29.519377 30.941405 26.580769 16.31882 2:00:00 AM 17.06693024 37.673798 33.667723 31.938764 27.072914 32.140855 17.186023 3:00:00 AM 19.43984722 41.196339 31.517793 29.670036 26.100667 33.267228 15.708261 4:00:00 AM 23.71719122 43.169752 36.105633 34.496885 31.54592 38.866652 21.379538 5:00:00 AM 24.68240627 48.257581 41.103589 39.509919 37.637852 42.083924 24.460009 6:00:00 AM 27.38303081 51.716832 41.937089 45.046124 40.397449 49.069008 24.756617 7:00:00 AM 34.42322941 64.312891 57.662735 45 266952 43.088519 57.47371 28.823902 8:00:00 AM 42.61331257 78.297056 66.159342 61.451581 57.485592 74.486093 34.818078 9:00:00 AM 48.30205284 88.176918 74.642123 70.57989 66.366118 83.754653 46.460385 10:00:00 AM 37.55534041 79.78442 65.945801 58.637683 53.161458 67.627094 36.076242 11:00:00 AM 42.22735134 80.360576 83.21481 60 203453 56.497115 74.964236 37.873544 12:00:00 PM 50.74941768 96.595129 91.401581 77373798 67.727341 88.945852 43.557561 1:00:00 PM 42.47873777 93.505153 81.297018 64 318223 61.717769 84.428696 39.616744 2:00:00 PM 37.75912042 73.887305 63.410616 57.083038 51.925061 69.108308 34.497314 3:00:00 PM 35.81579895 67.090208 58.384951 54.51821 50.768482 63.399254 33.8685 4:00:00 PM 32.42494065 62.812849 35.437345 46.655233 48.073496 61.722805 28.914685 5:00:00 PM 29.75712658 63.931318 56.214868 51.346236 48.480744 58.910087 28.8004 6:00:00 PM 32.564027 58.222848 51.437686 47.655273 43.773173 55.81668 28.143525 7:00:00 PM 23.20970568 53.285803 46.708265 42 516073 39.99436 47.35441 25.996101 8:00:00 PM 24.70495176 49.328089 39.753369 39.725828 32.881976 32.177311 18.836767 9:00:00 PM 21.97741418 43.617365 40.301784 40.288394 31.683676 30.672514 19.159309 10:00:00 PM 21.57221454 35.041132 34.063196 37.648352 32.211053 23.038875 18.582357 11:00:00 PM 24.66721764 32.779786 31.883353 32.837071 25.973378 19.338525 16.502403

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Ministers Tax And Financial Guide

Authors: Dan Busby, Michael Martin

2020 Edition

0310588790, 978-0310588795

More Books

Students also viewed these Accounting questions