Question: When multiple tables or data sets are used in data analysis, relationships of these tables should be created. Please open the five data sets used

When multiple tables or data sets are used in data analysis, relationships of these tables should be created. Please open the five data sets used for the project, which of the following is true about the relationships that should be created between sales.xlsx and psales.xlsx? When multiple tables or data sets are used in data analysis, relationships of these tables should be created. Based on the psales.xlsx and sales.xlsx as below, which of the following is true about the relationships that should be created between sales.xlsx and psales.xlsx? File Names Variables Description of Variables psales.xlsx fyear Fiscal year psales.xlsx gvkey Unique identifier for a firm psales.xlsx psales Projected sales revenue sales.xlsx fyear Fiscal year sales.xlsx gvkey Unique identifier for a firm sales.xlsx sale Actual sales revenue sales.xlsx csho Number of common shares outstanding sales.xlsx prcc_f Stock price - closing sales.xlsx and psales.xlsx are connected by both gykey and fyear sales.xlsx and psales.xlsx are connected by gvkey. sales.xlsx and psales.xlsx are connected by fyear variat psales.xlsx fyear psales.xlsx gvkey Description of Variables Fiscal year Unique identifier for a firm psales.xlsx psales Projected sales revenue sales.xlsx fyear Fiscal year sales.xlsx gvkey Unique identifier for a firm sales.xlsx sale Actual sales revenue sales.xlsx csho Number of common shares outstanding sales.xlsx prcc_f Stock price closing C sales.xlsx and psales.xlsx are connected by both gvkey and fyear. C sales.xlsx and psales.xlsx are connected by gvkey. C sales.xlsx and psales,xlsx are connected by fyear. C sales.xlsx and psales.xlsx can not be connected

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!