Fermé

Data analysis

So I have some data X,Y,Z.

I want to make a table where X,Y are the axis, and I give it some of the data for Z.

Now the bit that is tricky. My data of X,Y is pretty random. So I want excel to put it in to the nearest number or interpolate the number in the middle.

Example values for the chart: x values - 5,10,15,20,25,30

y values - 0,45,60,90

Data sample values: x values - 17.5,10.5,15.5,22, etc

y values - 50.3,45,38,57, etc

Ideally once I have built the chart with the known z data points the blank data points would be worked out

Any ideas on how to do this or if it is possible?

Compétences : Excel, Traitement de Données, Mathématiques, Python, Programmation Linéaire

Concernant le client :
( 0 commentaires ) Palma, Spain

Nº du projet : #33963716

37 freelances font une offre moyenne de 125 € pour ce travail

(574 Commentaires)
8.5
liveexperts123

Hi there,I'm biddin on your project "Data analysis " I have read your project description and i'm an expert in Python and machine learning therefore i can do this project for you perfectly.I still have a few questions. Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(122 Commentaires)
8.0
(479 Commentaires)
7.7
Fazeennazar

*** Python Expert for your project *** I read your project description very carefully. I have a deep understanding and experience in the areas of python that you mentioned. I've previously worked on so many projects f Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 2 jours
(179 Commentaires)
7.0
daniyal3214

Hello, I will be glad to assist you with that. I am an experienced Data Scientist and Data Visualization expert holding years of experience in performing Data Visualization, Data Analytics and Automation using Power BI Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(178 Commentaires)
7.1
(134 Commentaires)
6.9
SShtv

Hello, I am interested in your project. Your task is clear to me and I am ready to solve it. I have a large and successful practical experience of processing and analyzing data in Excel, including using the VBA. These Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(120 Commentaires)
6.5
(169 Commentaires)
6.4
(43 Commentaires)
6.7
datascientist90

I'm a senior Python & ML developer and owner & founder of Dedeoglu Dev Company. Kindly send me a message to get in touch with me, Thanks, Yusuf.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 7 jours
(24 Commentaires)
6.3
(117 Commentaires)
6.5
(43 Commentaires)
6.3
(93 Commentaires)
6.1
(52 Commentaires)
5.8
nycer847

Hello Dear, I see that you need a Matlab expert. Well, I am an expert in simulations using Python, MATLAB and SIMULINK in many fields including Electronics, Physics, Communication Systems, Control systems, Chemical Eng Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 7 jours
(9 Commentaires)
5.5
gogora

Hi Are those values mathematically dependent or do you have some ordered data (for example array[array[3]] where 3 are x,y,z values)? If this is not we could have a chart with blank values on the plot either with data Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 7 jours
(6 Commentaires)
5.5
(33 Commentaires)
5.4
(85 Commentaires)
4.8
VictorCcPhD

Hello, I can certainly help you with that tasks. I've been working a lot with data analysis in Excel. I am also an Excel VBA programmer. You can see some of the things I do in my blogs and YouTube channel (links in my Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 7 jours
(4 Commentaires)
4.9
(18 Commentaires)
4.3