Answered: Find the list of S&P 500 companies.…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

Question

Find the list of S&P 500 companies. Choose four companies from S&P 500 list that the first letter of their names is the same as the first four letters of your first name. For instance, my first name is ARASH. So, I need to choose four companies that their names start with A, R, A, and S. I choose: A: Amazon R: Royal Caribbean Group A: Apple S: Starbucks You must choose four companies based on your first name. and the first 4 letters are A , B, R, A Now do the following: 1) Create a dataframe in R that has the following columns for these four companies: Company_name Headquarters location city Headquarters location country (use US for the United States) Symbol Revenue in billion dollars Stock price Use appropriate names for your columns. Make sure that the classes of your column make sense. The class of Headquarters location country must be factor. a) Find the maximum value for revenue (use $ operator). b) Find the average for stock price (use $ operator). c) Create a new variable in your dataframe that is stock price times 2 (use $ operator).

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 4 steps with 2 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions