Question
Q5. ( 10 marks) The following data represents random costs (AED) of electricity during July 2018 for a random sample of 81 single bedroom apartments
Q5. ( 10 marks)
The following data represents random costs (AED) of electricity during July 2018 for a random sample of 81 single bedroom apartments in Dubai (cut and paste the data into excel)
477 484 140 456 643 432 812 443 303275 403 601 376 596 463 487 479 91
461 851 262 427 557 378 120 399 359582 183 418 409 464 289 460 443 850
442 564 546 491 306 623 585 498 490549 486 508 566 377 346 447 463 463
471 411 434 476 478 381 423 451 369488 364 616 292 417 512 485 513 341
609 502 531 403 360 338 450 522
Use Excel to find the below descriptive statistics of the above raw data (Costs in AED). Also write the excel command used
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started