Statistics Question

The question requirement to provided ( plagiarism+ AI ) report for All of the file

The two plagiarism files required for All of the file

• (File one) Turnitin plagiarism report for All the file must less than 15%)
• (File two) AI plagiarism report for All of the file must zero percentage)
• File three ( copy and paste any original paragraph you take the information from it in separate file )

The question : I need to do two question the

I attached the file excel need to correct them to do all variable measure do it quantitatively like I explain the point need to correct them to make the table quantitatively make sure all data available and public comply with IRB approval department then second make in word file each company separate table in separate page do the table like the same table in I attached excel file but make table separate for each company then under the table for each company write the page number for each variable reference number from original link and write small paragraph under each company how you collected the data

Example Capex page 6 paragraph number Ai page 2 paragraph number cloud page 8 paragraph number .for all variable

Here is your strict 7-point checklist to make your Excel file 100% quantitative and ready for statistical analysis.

• Standardize Financial Units (The “M” vs. “B” Rule)
  • Action: Choose one unit (e.g., Millions) and convert everything.
  • Correction: Change 10.3 B to 10300. Change 4820 (if raw) to 4.82.
  • Why: You cannot mathematically subtract “Billions” from “Millions” unless they are in the same magnitude.
• Strip All Non-Numeric Characters
  • Action: Use “Find & Replace” to remove all $, ,, M, B, and ~.
  • Correction: Change $3,671 M to 3671.
  • Why: Statistical software sees “$3,671” as text (like a word), not a number.
• Convert Tech Columns to Binary (Dummy Variables)
  • Action: For columns ERP, Cloud, AI, IoT, Automation.
  • Correction: Replace “High”, “Medium”, “Yes”, or “Core Business” with 1. Replace “No”, “N/A”, or “None” with 0.
  • Why: You cannot calculate the average of “High” and “Medium”. You can calculate the frequency of “1”.
• Quantify “Breadth” (Text to Integer)
  • Action: Delete words like “High”, “Diverse”, or “Focused”.
  • Correction: Replace them with the actual count of technologies found for that firm (e.g., change “High” to 7 if they have 7 techs).
  • Why: A regression model needs a continuous integer (0, 1, 2… 10) to measure correlation.
• Clean “IT Intangibles” & “CAPEX”
  • Action: Remove all explanatory text.
  • Correction: Delete sentences like “Internally-developed software capitalized as…”. Keep only the number. If the number is not explicitly stated, leave the cell empty (do not write “Not isolated”).
  • Why: Text in a numeric column causes errors in calculation formulas.
• Standardize Missing Data (Null Handling)
  • Action: Decide on a code for missing data.
  • Correction: If a company doesn’t report a number, leave it completely blank or use a specific code like -99. Do not use 0 unless the value is actually zero (e.g., zero debt).
  • Why: A blank cell is treated as “missing” by software; a 0 skews your average downwards.
• Verify with the “Sum Test”
  • Action: At the bottom of every column (Revenue, Breadth, AI), try to calculate a =SUM() or =AVERAGE().
  • Correction: If Excel gives you an error (#VALUE!) or the count looks wrong, you still have text hidden in that column. Fix it until the formula works.

Second question:

I need to answer this question in separate file based in your answer and file attached name chapter 1-3

• Explain how you will collect secondary data and its sources………
• You need to list the names of data sources and their URLs……..
• You need to list the names of data sources and their URLs….. and explain which type of data you will collect based on the conceptual model quantitatively I attached file name chapter 1-3 the have inside the conceptual model

Data source

Appendix A: Public Data Sources and Access Links
a. SEC EDGAR Search (Forms 10-K, 10-Q, 8-K; ):

b. SEC EDGAR Company Browse (issuer filing history):

c. SEC Search Filings Hub (EDGAR tools directory):

d. SEC EDGAR Search Assistance (user guide):

e. U.S. Bureau of Economic Analysis (BEA) industry/macro series (contextual controls):

f. Federal Reserve Economic Data (FRED) macro series (contextual controls):

g. Texas Comptroller of Public Accounts economic data (state-level context where needed):

h. AnnualReports.com (public access to company annual report PDFs where available):

Appendix B: SEC EDGAR Filing Links for the 40 Sampled Firms (Directly Verifiable Public Access)
These issuer-specific EDGAR links provide a direct, public route to each firms 10-K/10-Q/8-K filings used to extract all .

i. Texas Instruments Inc. (TXN) SEC filings: .

j. Dell Technologies Inc. (DELL) SEC filings: .

k. Flex Ltd. (FLEX) SEC filings: .

l. Cirrus Logic Inc. (CRUS) SEC filings: .

m. Silicon Laboratories Inc. (SLAB) SEC filings:
.
n. NXP Semiconductors USA Inc. (NXPI) SEC filings: .

o. Diodes Incorporated (DIOD) SEC filings:

p. Qorvo Inc. (QRVO) SEC filings: .

q. Leidos Holdings Inc. (LDOS) SEC filings: .

r. Lockheed Martin Aeronautics (LMT) SEC filings:

s. L3Harris Technologies ISR (LHX) SEC filings:

t. Raytheon Technologies (RTX) SEC filings:

u. Bell Textron Inc. (TXT) SEC filings: .

v. Trinity Industries Inc. (TRN) SEC filings:

.
w. TechnipFMC (FTI) SEC filings:

x. National Oilwell Varco (NOV) SEC filings:

y. Schlumberger Ltd. (SLB) SEC filings: .

z. Baker Hughes Company (BKR) SEC filings:

aa. Phillips 66 (PSX) SEC filings:

ab. HF Sinclair Corporation (DINO) SEC filings:

ac. ConocoPhillips (COP) SEC filings:

ad. Oceaneering International Inc. (OII) SEC filings: .

ae. Nabors Industries Ltd. (NBR) SEC filings: .

af. Flowserve Corporation (FLS) SEC filings:

ag. Caterpillar Inc. (CAT) SEC filings: .

ah. Lennox International Inc. (LII) SEC filings: .

ai. IES Holdings Inc. (IESC) SEC filings: .

aj. Heidelberg Materials North America (HEI) SEC filings:

ak. Daikin Comfort Technologies (DAIKIN) SEC filings:

al. Commercial Metals Company (CMC) SEC filings:

am. CompX International Inc. (CIX) SEC filings: .

an. Air Products and Chemicals Inc. (APD) SEC filings: .

ao. Air Liquide USA LLC (AIQUY) SEC filings:

ap. Kimberly-Clark Corporation (KMB) SEC filings:

aq. McKesson Corporation (MCK) SEC filings:

ar. Keurig Dr Pepper Inc. (KDP) SEC filings:

.
as. Fossil Group Inc. (FOSL) SEC filings: .

at. Tandy Leather Factory Inc. (TLF) SEC filings: .

au. Flowtrend Inc. (FLOW) SEC filings: .

av. Thermon Group Holdings Inc. (THR) SEC filings:

Get fast, custom help from our academic experts, any time of day.

Place your order now for a similar assignment and have exceptional work written by our team of experts.

Secure 100% Original On Time Delivery