answer the following questions 365
1)Which new features/capabilities in newer versions of Excel (2013 and up) make Excel more visualization friendly (choose all that apply)?
1)better Intergrated with Office Suite tools
2)Replacing the previous Power Query
3)more sophisticated data module
4)more statistical tools and charts are available
5)can access data from multiple (disparate) sources (data files, SQL Server, CSV, etc.) and unify in Excel.
***************************************************
8.Write a series of Python code that does the following:
(a) Defines a class object (MyCourse)
(b) Defines an array in this object init; set it with two values (your_name, my_start_score=0)
(c) Add three scores (80, 100, 95) to init and show results
(d) Calculate the average of all scores and show results in (MyCourse)
* Show the code and results after processing and, add an appropriate comment for each line of code
Write a series of R code that does the following:
(a) Outputs: This is the mid-term exam for (class name) at UC
(b) Creates a S3 Class Object with components – your name, today’s date, and the score you got on Quiz 1(APA)
(c) Creates a list that shows scores you received on three assignments thus far ( Quiz 1, Assignment 1, and Quiz 2)
(d) Calculates both the sum and average of these three scores
* Show the code and results after processing and, add an appropriate comment for each line o
*********************************************************************
- If you were hired next week as an entry-level Data Specialist and your company gave you a choice of using R or Python (but not both) as a visualization tool, which tool would you choose? Why? Give four reasons for your choice by comparing features, strengths or disadvantages of each tool
*******************************
- R is an object-oriented programming language. In fact, everything in “R” is an object. When evaluating the capability of a programming platform, we usually describe its structure. List 5 atomic vectors(data types) and 5 data structures supported in the “R” programming platform.