Answered You can hire a professional tutor to get the answer.
The data covers stock market trading for the Intel corporation in 1998.
Please help me with this Intel Stock question for CSC465 Data Visualization course using both R and Tableau:
The data covers stock market trading for the Intel corporation in 1998. Each row is a day, with the following columns: Date, Trading Day (integer day number, including skips), Open (price at market open), High (highest price of day), Low (lowest price of day), Close (price at market close),
a. Graph the closing price vs. the date with an ordinary line graph. If you use Tableau, you need to right-click on the Date and choose Exact Date from the dropdown menu so that it uses the full date with "day". Volume (shares traded), and Adj. Close (adjusted closing price, meaning accounting for stock splits, which are not a problem in this data). Make the specified graphs in either R or Tableau: b. Graph the Volume vs. the exact Date as in the last part with a bar graph.
c. Create a histogram of the daily stock Volume. R has the hist command and a ggplot geom. In Tableau, the Histogram graph type in the Show Me box will be useful. Experiment with the bin size. It's an optional parameter in the R functions (e.g. n=20 for hist or bins=20 for geom_histogram). In Tableau, after you have the histogram, right click the "Volume (bin)" in the data bar on the far left and use Edit. In Tableau, it's not the number of bins, but their width (in terms of data). You can set them that way in R as well with different parameters.
d. Create a scatterplot that graphs the Volume on the x-axis and the daily price range on the y-axis. You will need to create an additional column that contains the "range" of the prices for the day as the difference between the fields High and Low.
Range = High - Low
Tableau can do it with a Calculated Field. In R you can do it by making a new column equal to the result from subtracting the two columns. In Tableau, to get a scatter plot, you will need to right click on both the Range and Volume entries in graph and change them to "Dimensions".
