Answered: ted: library(RMariaDB) mydb <-…

COMPREHENSIVE MICROSOFT OFFICE 365 EXCE

1st Edition

ISBN:9780357392676

Author:FREUND, Steven

Publisher:FREUND, Steven

Chapter8: Working With Trendlines, Pivottables, Pivotcharts, And Slicers

Section: Chapter Questions

Problem 8EYW

See similar textbooks

Related questions

Concept explainers

Question

100%

I dont really know where to start. So please can someone help me out.

Use the Class Database to pick any S&P500 stock and a 30 calendar day period between Nov 15 and Dec 31, 2020. Create an ARIMA model and a time series plot predicting prices for the next 10 calendar days.

I would like to use Walmart as the stock Ticker: WMT. Thank you.

Use the following R code to get started:

library(RMariaDB)
mydb <- dbConnect(MariaDB(), user='student', password='cosc4347', dbname='SP500', host='oceanplatform0.cdb7tnix15tn.us-west-2.rds.amazonaws.com')
mystock <- "*your stock ticker here*"
sql <- paste("SELECT SUBSTRING(QtTime,1,10), AVG(QtPrice) FROM Quotes WHERE QtSymbol='", mystock, "' GROUP BY SUBSTRING(QtTime,1,10)", sep="")
rs = dbSendQuery(mydb, sql)

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Follow-up Questions

Read through expert solutions to related follow-up questions below.

Follow-up Question

How would I go about writing the code to get the data that's in the databases that my class has? This is in the program RStudio. Any help would be appreashed.

We have these packages
# Now let's install a few packages for the Introduction to R lecture
install.packages(c("dplyr", "e1071", "reshape2", "ggplot2", "zoo"))

Solution

by Bartleby Expert

SEE SOLUTION

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.

ted: library(RMariaDB) mydb <- dbConnect(MariaDB(), user='student', password='cosc4347', dbname='SP500', host='oceanplatform0.cdb7tnix15tn.us-west-2.rds.amazonaws.com') mystock <- "*your stock ticker here*" sql <- paste("SELECT SUBSTRING(QtTime,1,10), A

ted: library(RMariaDB) mydb <- dbConnect(MariaDB(), user='student', password='cosc4347', dbname='SP500', host='oceanplatform0.cdb7tnix15tn.us-west-2.rds.amazonaws.com') mystock <- "your stock ticker here" sql <- paste("SELECT SUBSTRING(QtTime,1,10), A