I expect you to present sample statistics, like means and standard deviations, for your main variables, and output from at least one regression from your data. This output will result in a mid-range...

MGED50 SAMPLE STATISTICS
MGED50 SAMPLE STATISTICS
Dhru Gohil
02/03/2022
library(dplyr)
##
## Attaching package: 'dplyr'
## The following objects are masked from 'package:stats':
##
## filter, lag
## The following objects are masked from 'package:base':
##
## intersect, setdiff, setequal, union
library(tidyverse)
## -- Attaching packages --------------------------------------- tidyverse 1.3.1 --
## v ggplot2 3.3.5 v purrr 0.3.4
## v tibble 3.1.3 v stringr 1.4.0
## v tidyr 1.1.4 v forcats 0.5.1
## v readr 2.0.0
## Warning: package 'tidyr' was built under R version 4.1.1
## -- Conflicts ------------------------------------------ tidyverse_conflicts() --
## x dplyr::filter() masks stats::filter()
## x dplyr::lag() masks stats::lag()
library(readxl)
library(ggplot2)
Reading in the datasets:
#my_data <- read_excel('/Users/dhrugohil/Desktop/MGED50/Research Paper/DATA/dataset.xlsx', sheet = "data")
#head(my_data)
This data set includes data from year(s) 2019-2020. The columns include the industry name, SIC code, revenue in millions for 2019 and 2020, the annual revenue growth rate from 2019-2020, the advertising budget for 2019 and 2020, the annual advertising growth rate from 2019-2020 and the advertising budget as a percentage of sales.
#startup <- read.csv(file = '/Users/dhrugohil/Desktop/MGED50/Research Paper/DATA/50_Startups.csv')
#head(startup)
This data set gives us an interesting look into the budget allocations for start up companies who will mostly benefit from this research. The columns include research and development spending, administration spending, marketing spending, the state in which the start up is located and the profit.
adv_type <- read.csv(file = "~/New folder (2)/advertising-budget-and-sales.csv")
drops <- c("X")
adv_type <- adv_type[ , !(names(adv_type) %in% drops)]
head(adv_type)
## TV.Ad.Budget.... Radio.Ad.Budget.... Newspaper.Ad.Budget.... Sales....
## 1 230.1 37.8 69.2 22.1
## 2 44.5 39.3...